worksheet name

[scottcts]

I'm trying to create a worksheet name based upon a cell reference from
another worksheet in the same workbook. For example, I would like the
worksheet's name to be a referential reference to cell A1 from worksheet2.

 

[Frank Kabel]

Hi
try
sub foo()
activesheet.name=worksheets("sheet2").range("A1").value
end sub

--
Regards
Frank Kabel
Frankfurt, Germany

I'm trying to create a worksheet name based upon a cell reference from
another worksheet in the same workbook. For example, I would like the
worksheet's name to be a referential reference to cell A1 from

worksheet2.

 

[scottcts]

Thanks. It works perfectly.

Hi
try
sub foo()
activesheet.name=worksheets("sheet2").range("A1").value
end sub

--
Regards
Frank Kabel
Frankfurt, Germany


worksheet2.

 

[Gord Dibben]

Scott

Sub SheetName22()
ActiveSheet.Name = Sheets("Sheet2").Range("A1")
End Sub

Gord Dibben Excel MVP