RENAME CHANGING SHEET NAME

[CJ]

Hi,
I'm trying to rename a sheet, after importing a text file which will always
have a different name, i.e COD 20051105, COD 20051106 Etc.
The sheeet name by default will inherit the file name, COD 20051105

I need to rename the sheet no matter what the name is, i've searched
and found this but it's dependant on a value all ready on the sheet
Can any one adapt this code to help me accomplish this task

Sub RenameSheet()
ActiveSheet.Name = ActiveSheet.Range("A2").Value
End Sub

Chris

 

[Joe4]

What do you want to change the name to?

If just a hard-coded, name simply use something like:

Sub RenameSheet() 
   ActiveSheet.Name = "MyNewName"
End Sub

 

[CJ]

Hi, jmiskey

Big thanks, just what I wanted

Thanks
Chris