Hello
I'm completely new to macros. I made a macro (mostly with the recorder tool) to:
1) Copy the current worksheet
2) Move a selection of data down one row on the new worksheet
3) Delete a row of data on the new worksheet
It works when I run it. I'm trying to add a button which will just run the macro once when I click the button, but I'm getting a "run-time error '1004': Select method of Range class Failed"
I assumed by wrapping the working macro with the code for the button, it would be enough, but I guess I'm missing something.
This is the code with no button.
This is the same code, but with the button.
I'm sure its all very sloppy, I'll be starting tutorials after this so that I'm not running in circles, but would appreciate some help with this.
Thanks
Bookmarks