Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Dynamic naming of worksheets
Hi,
I am developing a macro in which I add new sheets to a database every time I export data to it. In order to recognize these sheets, I would like to be able to make the name of the sheet equal to the contents of a cell in the exported sheet. Currently, the code reads Sheets("Sheet1").Select Sheets("Sheet1").Name = "Name" Is there anyway that I can make the "Name" - part into a dynamic cell-reference? Thanks Zyvind |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Dynamic naming of worksheets
Just use:
Sheets("Sheet1").Name = Sheets("Sheet1").Range("A1") or Sheets("Sheet1").Name = yourStringVariableHere or Sheets("Sheet1").Name = Sheets("Sheet1").Range (yourrangenamevariable) or Sheets("Sheet1").Name = Sheets("Sheet1").cells(1,1) etc ttfn benm |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Dynamic naming of range needed | Excel Worksheet Functions | |||
Dynamic Sheet Tab Naming | Excel Programming | |||
Dynamic Sheet Tab Naming | Excel Programming | |||
Dynamic Range Naming | Excel Programming | |||
Naming Worksheets in VBE | Excel Programming |