Lotus Macro

  • Thread starter Thread starter Gordon
  • Start date Start date
G

Gordon

Hi

I would like to know how to set a macros similar to the ones I used in Lotus
.... for Example

In Lotus when I moved around when setting a macro it would just go up and
down ... no matter where I start from ...
In excel ... it references specific cells to go to ... how do I just move up
or own with out going to a specific cell in an Excel macro??

Second .... I had an editing macro in Lotus where I could go to the end of
a cell and delete the last five characters and then go to the next cell.
when I try to do that in Excel ... it relaces the whole line with the one I
used in the macro ... How do I change the macro to just delete the last five
characters of each cell and then go on to the next cell ...

Thanks

Gordon
 
question 1. use activecell.offset(1,0).select to go down one. But you do NOT
need to select cells in excel to do something to them. Use
activecell.offset(1).value="Lotus"
question2 use a for/each macro with c.value=Left(c,len(c)-5). Post yours for
comments
 
Thanks for your help ...

I got the first one to work just fine but the 2nd one is giving me trouble
....

for/each macro with c.value=Left(c,len(c)-5)

I was getting an error when I coppied that into the macro

any further suggestions ??

Regards,

Gordon
 
You did NOT post your efforts.

Sub strip5()
For Each c In Selection
c.Offset(0, 1) = Left(c, Len(c) - 5)
Next
End Sub
 
Thanks very much ... got it to werk just fine

Is there is a manual for this that is for beginners like me ... the help in
excel is next to useless for me ...

Regards,

Gordon
 
There are many excel books for sale by several on this list. Goto your
computer store or hang around here and learn. Practice and the macro
recorder are your friend.
 
--
steveB

Remove "AYN" from email to respond
Gordon said:
Thanks very much ... got it to werk just fine

Is there is a manual for this that is for beginners like me ... the help
in excel is next to useless for me ...

Regards,

Gordon
Click to expand...
 
Back
Top