Results 1 to 7 of 7

Macro for hiding rows before print not working

Threaded View

  1. #1
    Forum Contributor
    Join Date
    08-24-2011
    Location
    Van Wert, Ohio
    MS-Off Ver
    Excel 2010, 2000
    Posts
    104

    Macro for hiding rows before print not working

    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
    Last edited by gocolonel77; 05-28-2013 at 10:14 PM. Reason: added code brackets

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1