How can I get each worksheet tab name to pull from cell C3?
 

Is there anyway to get Sheet 1's name to pull whatever is in cell C3 and
change the "Sheet 1" title to that cells content?

How can I get each worksheet tab name to pull from cell C3?
 

Run this small macro:

Sub nameit()
For Each ws In Worksheets
ws.Name = ws.Range("C3").Value
Next
End Sub

--
Gary''s Student - gsnu200789


"BZ" wrote:

Is there anyway to get Sheet 1's name to pull whatever is in cell C3 and
change the "Sheet 1" title to that cells content?