98.7% Of all customers recommend us, we're so confident about our results we publish all reviews and stats
View Live Stats View Reviews
Forum home » Delegate support and help forum » Microsoft VBA Training and help » vba courses london - Create New Sheet & Specify Location
vba courses london - Create New Sheet & Specify Location
Resolved · Low Priority · Version Standard
Tue 17 Apr 2007, 08:44Delegate Simon said...
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.
Thu 19 Apr 2007, 09:34Trainer Carlos said...
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
Training information:
|
Welcome. Please choose your application (eg. Excel) and then post your question. Our Microsoft Qualified trainers will then respond within 24 hours (working days). Frequently Asked Questions
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
VBA tip:Empty The Clipboard with CutCopyModeAfter each Copy/Paste operation in VBA, you should use the following line of code to empty the clipboard. This ensures that the computer memory doesn't overload: |
