View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Teak[_2_] Teak[_2_] is offline
external usenet poster
 
Posts: 3
Default How not to fixed cell address in Macros

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