I have a very simple macro that deletes a load of rows based on the contents.
I added a button to the top of the spreadsheet to make it simpler to run, but as the macro runs and rows are deleted, my button disappears with it!
Any tips on how to get round this? Is there a setting for the button I can change?
Thanks
I added a button to the top of the spreadsheet to make it simpler to run, but as the macro runs and rows are deleted, my button disappears with it!
Any tips on how to get round this? Is there a setting for the button I can change?
Thanks