View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
marcia2026 marcia2026 is offline
external usenet poster
 
Posts: 48
Default 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