Hi Guys,
Im getting an error when I try to select a range on a sheet i've just selected
the code below shows where this is happening.
If CheckBox2.Value = True Then
For Each ws In ThisWorkbook.Worksheets
If ws.Name <> "Welcome" And ws.Name <> "Data" And ws.Name <> "Print" Then
ws.Select
Range("A1").Select
Application.Run ThisWorkbook.Name & "!HideCrews"
Sheets(ws).Range("A1").Select
End If
Next ws
End If
For all sheets who's name does not equal Welcome, Data or Print
Select that worksheet
select range on worksheet
run macro HideCrews
Is this happening because ws isnt assigned as the worksheet name?
if so how would I assign ws = worksheet.name
If CheckBox2.Value = True Then
For Each ws In ThisWorkbook.Worksheets
If ws.Name <> "Welcome" And ws.Name <> "Data" And ws.Name <> "Print" Then
nm = ws.Name
Sheets(nm).Select
Range("A1").Select
Application.Run ThisWorkbook.Name & "!HideCrews"
Sheets(ws).Range("A1").Select
End If
Next ws
End If
Thanks in advance
Bookmarks