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.