Adapt this to your needs:
![]()
Sub WhatsInAName() Dim s As Worksheet For Each s In Worksheets s.Range("A1:B10").Name = s.Name & "TABLE1" s.Range("D10:D20").Name = s.Name & "TABLE2" Next End Sub
Adapt this to your needs:
![]()
Sub WhatsInAName() Dim s As Worksheet For Each s In Worksheets s.Range("A1:B10").Name = s.Name & "TABLE1" s.Range("D10:D20").Name = s.Name & "TABLE2" Next End Sub
Gary's Student
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks