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("Sheet1").Name = "Import"
Open in new window
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?