View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
[email protected] dennis.mccarthy@us.atlascopco.com is offline
external usenet poster
 
Posts: 16
Default adding worksheet with macro but need to get back to 1st sheet

I have a macro adding a worksheet to a workbook. I am using:

ActiveWorkbook.Sheets.Add after:=Worksheets(Worksheets.Count)

I then need to "get back" to the first sheet to make it active -
problem is I cannot reference it by its name - the name on the first
sheet will change each time I use this workbook.

Any help would be greatly appreciated

Thanks in advance.