Hi - I have a macro that creates new sheets and it works fine except one of the criteria is based on the contents of the active cell of a sheet.
I've tried using ActiveCell.Copy, but that doesn't work.
Is there a VBA script that will copy the contents of the cell then follow my macro to create the new sheet when it pastes?
I have to highlight the numbers in the cell, copy, then run the macro so it pastes from the clipboard - this if frustrating and not making the process automated.
Any suggestions?
Bookmarks