Change Sheet Name

R

Ranjith Kurian

I need a macro to change my sheet name.

When i open my workbook it allways have a different sheet name everyday(the
sheet names are not constant) so i need to change it to as i require (change
to Rec), i my workbook i will have only one sheet.
 
R

Rick Rothstein

I'm not sure I understand why your sheet's name changes; but, since you only
have one sheet in the workbook, you can just assign whatever name you want
to the Name property of the ActiveSheet...

ActiveSheet.Name = "Rec"
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Run macro from active workbook whose name keeps changing 20
Copy data into sheets 13
enter key behavior - by sheet 4
Unable to change ActiveSheet within Workbook_Open 2
Excel Move or Copy Stopped Working? 0
How to change a sheet name without opening the workbook 3
Export Sheet Values to new workbook 20
application.activesheet, should I use it? 3

Top