troubleshooting Question

Excel New a worksheet in a macro

Avatar of SQLSearcher
SQLSearcher asked on
Microsoft DevelopmentMicrosoft ExcelSpreadsheets
3 Comments1 Solution476 ViewsLast Modified:
Hello Experts Exchange
I have a Excel 2010 spreadsheet that I want a macro to create a new worksheet and give it a name of import.

I have recorded a macro and have the following code;
Sheets.Add After:=Sheets(Sheets.Count)
    'Sheets("Sheet1").Name = "Import"

However I am running the macro on many different Excel files, and Sheet1 maybe not be the new worksheet name in some files.

Can you provide the code I would need to create a new worksheet and rename it to import, please?



Join our community to see this answer!
Unlock 1 Answer and 3 Comments.
Start Free Trial
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 3 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros