Cell Reference Macro

[Flenley]

I have written/ slashed recorded some macros that reference to a particular cell and row reference.

If someone inserts a row above this then the macro will not adjust with the new reference. It will still look for the old row reference.

Is there a way around this so that if people insert a new row then the macro will adjust?

Thanks

Angus

 

[Fryer Tuck]

Name the cell (Insert, Name, Define), then refer to the name in your reference.

Example, if you have named cell D4 as "Test"

then Range("Test") refers to that cell D4.

If someone inserts a row at line 2, then "Test" will now be at D5.

F.T.

 

[Flenley]

Thanks for your help!

Works Great