How not to fixed cell address in Macros

T

Teak

I used macro to record some steps.
When I run the macro, I got errors becos the cell address are hard-coded in
the macro.
what to do if I want the macro to do things like these, starting at the
active cell?

subtotal
move 2 cells left
type a text
insert a row
 
T

Tushar Mehta

See the Excel/VBA/Beyond Excel's recorder page of my web site.

--
Regards,

Tushar Mehta
www.tushar-mehta.com
Business solutions leveraging technology
Microsoft Most Valuable Professional (MVP) 2000-2004
 
G

Gord Dibben

Teak

When recording the macro, first hit the "Relative Reference" button on the
Stop Recording Toolbar.

Gord Dibben Excel MVP
 
Top