I want the tab names in my workbook to be cell references. If it is a Macro
function I will need the formula.
I want the tab names in my workbook to be cell references. If it is a Macro
function I will need the formula.
PDS,
This formula gets your sheet name in cell A1:
=MID(CELL("Filename",A1),FIND("]",CELL("Filename",A1))+1,255)
Syed
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.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks