Home » Forums » Open Source Learning Center » Question and Answer

VBA Help

Submitted by carlmh311 on 22 March, 2011 - 18:51
I need help correcting the following VBA code. It is a macro to set print area on an excel worksheet where the print area constantly changes. 
  Cells.Select
    ActiveSheet.PageSetup.PrintArea = ""
    Range("A1").Select
    Application.Goto Reference:="printrangeselect"
    Range(Selection, Selection.End(xlDown)).Select
    ActiveSheet.PageSetup.PrintArea = "printrangeselect" & Range(Selection, Selection.End(xlDown)).Select
    ActiveWindow.SmallScroll Down:=-6
    Range("A1").Select
I am erroring out on the following code in the debugger: 
ActiveSheet.PageSetup.PrintArea = "printrangeselect" & Range(Selection, Selection.End(xlDown)).Select
‹ Copying cell data from Workbook A to Workbook B Need VBA Coding for creating rows ›
»
Nick's picture

PageSetup

Submitted by Nick on 22 March, 2011 - 20:23.
try: 
ActiveSheet.PageSetup.PrintArea = Selection.Address
»