Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How can I make the names for Sheet tabs a reference to a cell?
I want the tab names in my workbook to be cell references. If it is a Macro
function I will need the formula. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
How can I make the names for Sheet tabs a reference to a cell?
PDS, This formula gets your sheet name in cell A1: =MID(CELL("Filename",A1),FIND("]",CELL("Filename",A1))+1,255) Syed -- saziz ------------------------------------------------------------------------ saziz's Profile: http://www.excelforum.com/member.php...fo&userid=6350 View this thread: http://www.excelforum.com/showthread...hreadid=539416 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
How can I make the names for Sheet tabs a reference to a cell?
This may help:
Sub Macro1() Sheets(1).Select Sheets(1).Name = Cells(1, 1).Value End Sub This tiny macro will set the name of the tab equal to the value in cell A1, for the first tab.. It can be easily modified to loop over all tabs, use different cells, etc. -- Gary''s Student "PDS" wrote: I want the tab names in my workbook to be cell references. If it is a Macro function I will need the formula. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Maintaining cell reference after sorting | Excel Discussion (Misc queries) | |||
How to have a variable cell reference across sheets? | Excel Discussion (Misc queries) | |||
Possible Lookup Table | Excel Worksheet Functions | |||
Flexible Cell Reference | Excel Discussion (Misc queries) | |||
how to make cell address reference increment? | Excel Worksheet Functions |