Rename Worksheets with Macro

  • Thread starter Thread starter Eric Larsen
  • Start date Start date
E

Eric Larsen

I would like to have a Macro to go to a certain cell to rename a worksheet.
When I run I get errors.
Can someone lend a hand?
 
Eric,

Is your code something like this?

With Worksheets(1)
.Name = .Range("A1").Value
End With
 
Back
Top