MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Renaming Tabs in a worksheet


Posted by Tom on August 22, 2000 3:17 PM

I have a text file that I import into Excel 97 using a macro.
When you bring a text file in it only creates 1 worksheet.
What I'm trying to do is copy the orginal data into new
worksheet in the same workbook, then rename the orginal
tab to ("orginal data") then rename sheet1 to "copied data".
Is it possible to do this using a macro?



Posted by Kristen on August 22, 0100 7:24 PM

Yes it is... you may find a good way to start is to record a new macro. Excel will watch & record everything you do and write the relevant code for you. You may still have to tweak it but it's a good starting point.

cheers,

Kristen