Hi. I am using Excel 2000 and am new to using VBA.
What I need is the VBA code for simple cusor movements.
(These may sound crazy, but I have sound reasons
for needing this code.)
What is the VBA code to move the cursor (not the contents)
-- just the cursor ...
one cell DOWN ? one cell UP ? one cell to the RIGHT ?
one cell to the LEFT ?
Likewise, what is the VBA code to move 5 cells DOWN ?
5 cells UP ? 5 cells to the RIGHT ? 5 cells to the LEFT ?
Also, suppose a column is filled with 10 rows of data and
the cursor is at the top of the column/list. What VBA code
woudl move the cursor instantly DOWN to the END of that row
of data (to the 10th row). (Need to know what is the equiv.
of the manually applied END-DOWN keystroke sequence.)
Similarly, what is the VBA code for manually applied END-
RIGHT keystroke sequence.
Last, is there any web reference you can recommend which
shows coding examples for old Lotus 123 macro commands
to their equivalents in Excel 2000 VBA code ?
I know I've asked a lot. I truly appreciate any help you can
send my way.
Thanks very much ... Ken
What I need is the VBA code for simple cusor movements.
(These may sound crazy, but I have sound reasons
for needing this code.)
What is the VBA code to move the cursor (not the contents)
-- just the cursor ...
one cell DOWN ? one cell UP ? one cell to the RIGHT ?
one cell to the LEFT ?
Likewise, what is the VBA code to move 5 cells DOWN ?
5 cells UP ? 5 cells to the RIGHT ? 5 cells to the LEFT ?
Also, suppose a column is filled with 10 rows of data and
the cursor is at the top of the column/list. What VBA code
woudl move the cursor instantly DOWN to the END of that row
of data (to the 10th row). (Need to know what is the equiv.
of the manually applied END-DOWN keystroke sequence.)
Similarly, what is the VBA code for manually applied END-
RIGHT keystroke sequence.
Last, is there any web reference you can recommend which
shows coding examples for old Lotus 123 macro commands
to their equivalents in Excel 2000 VBA code ?
I know I've asked a lot. I truly appreciate any help you can
send my way.
Thanks very much ... Ken