macro question
 

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

macro question
 

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

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"CMD" wrote in message
...
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

macro question
 

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" wrote in message
...
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

macro question
 

Thanks, Jeff. Very helpful!!

"Dude Ranch" wrote:

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" wrote in message
...
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

macro question
 

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

http://www.tushar-mehta.com/excel/vb...rder/index.htm

Good tips to ne found.


Gord Dibben MS Excel MVP

On Mon, 4 Feb 2008 08:08:03 -0800, CMD wrote:

Thanks, Jeff. Very helpful!!

"Dude Ranch" wrote:

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" wrote in message
...
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