Want to add a user defined selection
Hi, I am using a copy of Ron de Bruin's "Copy to Worksheets" macro. I would
like to enter a place for the user to define which worksheet to copy. The
number of sheets each month will vary and names will vary. Otherwise, works
great.
This is the current line of code:
'Name of the sheet with your data
Set ws1 = Sheets("Sheet1") '<<< Change
|