jeff.j.griffith
12/12/2006 6:38:00 PM
Would this work?
Dim objWorksheet As Worksheet
For Each objWorksheet In ActiveWorkbook.Worksheets
objWorksheet.Name = "Your Name Here"
Next objWorksheet
JR_06062005 wrote:
> Is there another way to rename a worksheet other than
> ActiveWorkSheet.Name="New Name"?
>
> I would like to rename a series of worksheets, but am not sure how to do
> this without selecting each one.