I want my macro to 1) create a new sheet and 2) copy data from another sheet onto the new sheet. For some reason it (my macro) will create the sheet but does not copy the data range (or any data at all) from the older sheet onto the newly created sheet.
I am doing a copy and then paste special (values).
Macro to create new sheet and copy data
Excel macro create new sheet copy data - Best answers
Excel macro to create new sheet and copy data - Best answers