Here is the For Loop I used to to find the name and range for a Workbook
But now how do I just replace the Workbook with the following code above with the one below with If (Left(wsh.Name, 3) = "001")![]()
For Each wsh In ThisWorkbook.Worksheets If (Left(wsh.Name, 3) = "001") Then Set Rng = wsh.Range("A1").CurrentRegion Exit For End If Next
![]()
Sheets("001_Table").Select
Bookmarks