Unhide

  • Thread starter Thread starter Roxy
  • Start date Start date
R

Roxy

I have this code

Sheets("Family Totals").Rows(5).Select
Selection.EntireRow.Hidden = False
Sheets("Extra Earned Income Methd 1").Select

I get the runtime error 1004 select method of range class failed
Can someone help me figure this out?
Thanks
Roxy
 
You can only select a range on a sheet that is active:

Sheets("family totals").select
Sheets("Family Totals").Rows(5).Select
Selection.EntireRow.Hidden = False

But you don't need to select at all:
Sheets("Family Totals").Rows(5).Hidden = False
 
Back
Top