Set print area in VBA/ Excel 2000

How do you set the print area to a variable range in Excel 2000?


Comments

  • : How do you set the print area to a variable range in Excel 2000?

    :

    areaSheet = "$B$1:$N$" + CStr(mR - 1)

    with thisworkbook.Activesheet

    .PageSetup.PrintArea = areaSheet

    end with






Sign In or Register to comment.

Howdy, Stranger!

It looks like you're new here. If you want to get involved, click one of these buttons!

Categories