| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Sheet Name as a Variable?
Hiya experts!! I have recorded!!!!  (shame? naaah I have no shame!! :) ) macro that inserts new spreadsheets into the workbook and it just fail to deliver because of the set name e.g. "Sheet2". Could you please let me know how to make this new sheet a variable an then via a msgBox enable the user to rename it? I guess it would b something like that: Sheets("VARIABLE").Name = "msgBox INPUT" Many thanks! -- Petitboeu ----------------------------------------------------------------------- Petitboeuf's Profile: http://www.excelforum.com/member.php...fo&userid=1060 View this thread: http://www.excelforum.com/showthread.php?threadid=49517 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Add sheet name into a variable. | Excel Worksheet Functions | |||
| variable sheet name | Excel Discussion (Misc queries) | |||
| How To make a sheet reference Variable (eq: sum(sheet!D2:H2)) | Excel Discussion (Misc queries) | |||
| Variable sheet and Formula Sheet | Excel Discussion (Misc queries) | |||
| variable in a link where the variable is the name of the sheet | Excel Worksheet Functions | |||
![Petitboeuf[_5_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Threaded Mode
