| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
having the same name for a lst, on multiple sheets
Is it possible to have the same name for my database list on multiple
sheets. Could someone show me the correct syntax to do that through VBA please. Say the name I want to add is "Database" and I want to add it on a sheet named "Retail" and a sheet named "Hotel" Thanks, Eric |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
having the same name for a lst, on multiple sheets
Worksheets("Retail").Range("A1").Name = "Retail!Database"
or: ActiveSheet.Range("A1").Name = ActiveSheet.Name & '!Database" etc. -- Vasant "Eric" wrote in message nk.net... Is it possible to have the same name for my database list on multiple sheets. Could someone show me the correct syntax to do that through VBA please. Say the name I want to add is "Database" and I want to add it on a sheet named "Retail" and a sheet named "Hotel" Thanks, Eric |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to update data from multiple sheets to one specific sheets | Excel Discussion (Misc queries) | |||
| SUMPRODUCT, SUMIF, COUNTIF for multiple sheets for multiple criter | Excel Worksheet Functions | |||
| Automated multiple text files into multiple sheets in one workbook | Excel Discussion (Misc queries) | |||
| Multiple Sheets (Need to create 500 individual sheets in one workbook, pulling DATA | Excel Worksheet Functions | |||
| Changing the value in multiple sheets without selecting those sheets | Excel Programming | |||
![Eric[_27_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Linear Mode
