View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Spamfighter Spamfighter is offline
external usenet poster
 
Posts: 2
Default What would be Excel's equivalent for a Lotus line "[Input].MoveCellPointer $Right,1"?

Recording a macro in Excel after

Selection.End(xlToLeft).Select
Selection.End(xlToLeft).Select

to move past a column (BE), I end up at the last column with data
I move the curser to the next column on the right I get

Range("T5").Select

i.e. an absolute location. That is not what I need as after entering data
into this column, the next time I execute the macro I like to end up at "U5"
etc.

Testing the recording of the same macro in Lotus I end up after

[Input].MoveCellPointer $EndLeft,1
[Input].MoveCellPointer $EndLeft,1

and moving the curser to the nect column on the right I get

[Input].MoveCellPointer $Right,1

Thus in Lotus it works fine as I always end up at the correct column

Anyone knows the equivalent Excel macro line which doesn't move me to an
absolute location but just the next column to the right?

Thanks, Willi