Worksheet names

[jkepley75]

Is there anyway to name a worksheet with text from a cell in anothe
worksheet

 

[Frank Kabel]

Hi
only with VBA. using something like

sub rename()
dim wks as worksheet
dim target_wks as worksheet
set wks = activesheet
set target_wks = worksheets(1)
target_wks.name=wks.range("A1").value
end sub

 

[jkepley75]

Thank you this helped a lo