Hello there,
I am trying to rename my worksheets based on the contents from 2 cells.
I have the following macro which renames based on 1 cell but i can't seem to get the range to work for two.
Sub RenameSheet()
Dim rs As Worksheet
For Each rs In Sheets
rs.Name = rs.Range("A1")
Next rs
End Sub
All help is much appreciated.
Thanks
Bookmarks