macro question

[CMD]

Hi. I have been using the macro recorder to build a few macros.

After I create the macro, it seems as if I have minimal flexibility in
modifying the page. For example, if I simply insert a row, the macro doesn't
make the necessary adjustments and shift everything down. Is there a way
around that?

Thanks,

Chris

 

[Don Guillett]

Gee, kind of hard to tell without seeing your macro and layout.

 

[Dude Ranch]

Chris - if you are new to the VBA game can I suggest you press the "Relative
Reference" button when recording your macro. This will give you an insight
into what is required to make Dynamic (rather than absolute) macro's.

This will hopefully jog you to further ready

Aloha
Jeff

 

[CMD]

Thanks, Jeff. Very helpful!!

Chris - if you are new to the VBA game can I suggest you press the "Relative
Reference" button when recording your macro. This will give you an insight
into what is required to make Dynamic (rather than absolute) macro's.

This will hopefully jog you to further ready

Aloha
Jeff

 

[Gord Dibben]

See Tushar Mehta's site for "Beyond the macro recorder"

http://www.tushar-mehta.com/excel/vba/beyond_the_macro_recorder/index.htm

Good tips to ne found.


Gord Dibben MS Excel MVP