I recorded a macro to copy and paste to my history sheet and it works when I use the ctrl A function, but when I assigned the same code to the command button; it stops working and gives me an error.
Why won’t the code work with the command button? I haven’t got to it yet, but I need the history page to keep dropping one row for the new data every time it copies and paste the information. This way it won’t overwrite data.
When I return to sheet1, the selection I copied is still selected, is there a way to deselect this automatically so when I return to the page it isn’t selected?
This is the code that was recorded.
Bookmarks