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
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