Navigate by macro
..Offset(0,1)
So if you macro says
Range("C6").Select
use
Range("C6").Offset(0,1).Select
--
HTH
Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)
"Rey A." wrote in message
...
To all gurus:
How can I replace the cell address after recording a macro by just the
"right arrow", meaning move to right of the cell address?
Thanks for the help.
|