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


Roxy wrote:

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

--

Dave Peterson