I have two Issues I need to figure out. I want to add all the worksheets as a list in my summary sheet starting in A4. Also, I have created a worksheet which I would like to use as a template for every new opened worksheet. Is this possible? For the first part I tried using this:
Columns(1).Insert
For i = 1 To Sheets.Count
Cells(i, 1) = Sheets(i).Name
Next i
But that adds a new column and its the only way I know how to list the sheets. Any help would be greatly appreciated.
Bookmarks