When you record a macro, a toolbar with two buttons pops
up. Click on the 'Relative Reference' button, and this
should solve your problem.
-----Original Message-----
When writing a macro, it seems that excel looks at the
exact cell you are in.
I want the macro to perform the function of going to the
right after the tab
key is pressed, no matter what cell I start in. Anybody
know how to do that?
.