CJ
Board Regular
- Joined
- Feb 22, 2002
- Messages
- 77
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
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