adding worksheet with macro but need to get back to 1st sheet
On Dec 13, 4:36 pm, excelent
wrote:
sheets(1).select
" skrev:
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.- Hide quoted text -
- Show quoted text -
How would this work if it was different workbooks ? The sheet
examples worked great
|