J
jeff
HI,
Couldn't see all of your question, but this little
code names the active sheet with the contents of
cell A1. You can make it automatic by right-clicking
the tab and goto view code, put it in worksheet change
or selection change or hook it up to a button.
your choice.
Sub nameSht()
ActiveSheet.Name = Range("A1")
End Sub
hth. jeff
Couldn't see all of your question, but this little
code names the active sheet with the contents of
cell A1. You can make it automatic by right-clicking
the tab and goto view code, put it in worksheet change
or selection change or hook it up to a button.
your choice.
Sub nameSht()
ActiveSheet.Name = Range("A1")
End Sub
hth. jeff