![]() |
#1
|
|||
|
|||
![]()
Hi
I'm trying to rename a worksheet tab via VBA. My problem is that the tab has a changing name. EG Sheets("Sheet1").Select Sheets("Sheet1").Name = "File 1" "Sheet1" in this case will change in name next time I want to run the macro , so it will fail. How can I build in a variable for the sheet selection so I can always rename it 'File 1' , whatever it used to be. It's always and only the first sheet I'm applying this to , by the way. Grateful for any help. |
|
![]() |
||||
Thread | Thread Starter | Forum | Replies | Last Post |
How to Rename a Quick Part | sleake | Word | 14 | 10-14-2013 09:21 AM |
![]() |
tinfanide | Excel Programming | 2 | 06-10-2012 10:17 AM |
Rename Files | gsrikanth | Excel Programming | 3 | 05-14-2012 03:03 AM |
![]() |
meggenm | Excel | 4 | 02-04-2012 02:04 AM |
![]() |
cksm4 | Word VBA | 2 | 02-25-2011 09:29 AM |