Lotus Macro

[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

 

[Don Guillett]

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

 

[Gordon]

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

 

[Don Guillett]

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

 

[Gordon]

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

 

[Don Guillett]

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.

 

[STEVE BELL]

--
steveB

Remove "AYN" from email to respond

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

 

[STEVE BELL]

Check out these sites: (there are many more)

http://www.cpearson.com/excel.htm

http://www.contextures.com/index.html

http://www.peltiertech.com/index.html

http://www.rondebruin.nl/tips.htm from this site download Google
Search add-in

www.tushar-mehta.com


Go to Google and search for "Excel" and "Tutorial"

And finally - just monitor this ng - great stuff here...