Macro for hiding rows before print not working

**gocolonel77** · 05-28-2013, 08:40 PM

I am having an issue with debugging

Runtime error 438
Object doesn't support this property or method

Here is my code:

Sheets("EXECUTIVE SUMMARY").Select
ActiveSheet.PageSetup.PrintArea = "$A$1:$Z$57"
ActiveSheet.Rows("13:41").Select

ActiveSheet.Selection.EntireRow.Hidden = True

ActiveSheet.SmallScroll Down:=-12
ActiveSheet.SelectedSheets.PrintOut
ActiveSheet.Rows("12:42").Select
ActiveSheet.Selection.EntireRow.Hidden = False
ActiveSheet.SmallScroll Down:=3
ActiveSheet.PageSetup.PrintArea = "$A$1:$Z$27"

The code line that is standing alone is where my debugger is directing me towards, but I am unfamiliar enough to work this through to a working solution.

Can you/anybody be of assistance.

Thanks in advance

**p24leclerc** · 05-28-2013, 09:55 PM

Can you first place your code in CODE BRACKETS? You are not a new forum user and this issue prevent any answer for the moment.
Answer is quite simple, though.

**gocolonel77** · 05-28-2013, 10:15 PM

Thanks p24leclerc. I am new to posting code, so I am glad to have learned something new today.

**p24leclerc** · 05-28-2013, 10:44 PM

Try this

Selection.EntireRow.Hidden = True

**billstpierre79** · 05-28-2013, 10:50 PM

Try this

Sheets("EXECUTIVE SUMMARY").Select
ActiveSheet.PageSetup.PrintArea = "$A$1:$Z$57"
ActiveSheet.Rows("13:41").Hidden = True
ActiveSheet.PrintOut
ActiveSheet.Rows("13:41").Hidden = False

**gocolonel77** · 05-28-2013, 10:57 PM

Sheets("EXECUTIVE SUMMARY").Select
ActiveSheet.PageSetup.PrintArea = "$A$1:$Z$57"
ActiveSheet.Rows("13:41").Select
Selection.EntireRow.Hidden = True

ActiveSheet.SmallScroll Down:=-12

ActiveSheet.SelectedSheets.PrintOut Copies:=1, Collate:=True
ActiveSheet.Rows("12:42").Select
ActiveSheet.Selection.EntireRow.Hidden = False
ActiveSheet.SmallScroll Down:=3
ActiveSheet.PageSetup.PrintArea = "$A$1:$Z$27"

Thanks, that was simple. Now the line below the initial problem is giving me the same error message. The line in questions stands alone in the line of code.

Thanks again.