Rename Worksheets with Macro

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?
 
E

Ed

Eric,

That is a common task.
Copy and paste the code here so we can try to find the
problem.
 
B

Bob Phillips

Eric,

Is your code something like this?

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