I have a spread sheet many times the size of the screen. I would like to be able to copy a control button from the last column of the sheet to the new last column after a large number of columns have been added.
When I run a macro to do this it uses pixels, I think; ie it references the screen not the excel grid. Is it possible to use a cell reference to locate the button ?