Simon has attended:
Excel VBA Intro Intermediate course
Create New Sheet & Specify Location
Dear Sir / Madam,
I want to create a new sheet in excel. I have two existing sheets and when I create a new one it automatically puts it at the start before my two existing ones.
Can you please advise me on when my VBA code creates a new sheet, it puts it at the end after my two existing sheets rather than before my two sheets.
Hope this makes sense?!
Kind Regards,
Simon.
RE: Create New Sheet & Specify Location
Simon
The code to create a new sheet and place it after the existing sheets is:
Sheets.Add After:= Sheets(Sheets.Count)
Regards
Carlos