Error When Selecting Sheet then Selecting Range

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.

Please Login or Register  to view this content.

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

Please Login or Register  to view this content.

Thanks in advance

Try this...

Please Login or Register  to view this content.

Or better yet...

Please Login or Register  to view this content.