| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
recognize a sheet
I want to make a copy of the 1st sheet and then rename it. the name of the sheet is always changing, anyway I can get VB to select the sheet no matter what it's name is? Sheets("sheet-x").Copy After:=Sheets(1) Sheets("sheet-x (2)").Select Sheets("sheet-x (2)").name = "sheet-y" -- zerosleep ------------------------------------------------------------------------ zerosleep's Profile: http://www.excelforum.com/member.php...o&userid=17846 View this thread: http://www.excelforum.com/showthread...hreadid=518695 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| trying to get sheet 1 to recognize and move student names to pg 2 | Excel Worksheet Functions | |||
| How do I link cells, sheet to sheet, to recognize row deletions? | Excel Discussion (Misc queries) | |||
| How recognize sheet protected? | Excel Worksheet Functions | |||
| How do I link cells, sheet to sheet, to recognize row deletion | Excel Programming | |||
| Getting VBE to recognize a new sheet | Excel Programming | |||
![zerosleep[_3_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Threaded Mode
