I have a simple macro which works well - created using macro recorder as I am not a VBA code generator!!! However, it uses relative references because I want to add rows and copy formulae into a block of cells that will itself appear multiple times as a result of another copy and paste macro. So the button would appear in each block.
The problem is that everyting is based on the assumption that the correct cell is selected before the macro runs - and if it isn't chaos ensues! If I could locate a button in a cell rather than over a cell, so that clicking the button automatically selected the approriate cell before the macro runs all would be well. Is this possible?
I have attached a file to show what I am trying to do - I am afraid that I am very much self taught and this may be far from the optimimum approach but if only I could protect against the macro being run from the wrong cells I would be happy!
Thanks,
RDS
Bookmarks