Help! Set Ranges Based on Print Areas in VBA?

**amanda12345** · 07-23-2013, 05:29 PM

Hi,

I am trying to copy and paste values from specific ranges within specific worksheets into a new workbook using VBA. Is there a way to set the ranges based on the print areas I have already set for each of these worksheets? I am trying to avoid having to set a different range for each individual worksheet.

Thanks!

**shg** · 07-23-2013, 05:52 PM

    Dim wks         As Worksheet
    Dim r           As Range

    Set wks = ActiveSheet

    With wks
        If Len(.PageSetup.PrintArea) Then
            Set r = .Range(.PageSetup.PrintArea)
        Else
            Set r = .UsedRange
        End If
    End With

Help! Set Ranges Based on Print Areas in VBA?

LinkBack

Thread Tools

Rate This Thread

Display

Hybrid View

Help! Set Ranges Based on Print Areas in VBA?

Re: Help! Set Ranges Based on Print Areas in VBA?

Thread Information

Users Browsing this Thread

Similar Threads

VBA code to print several print areas in one worksheet

Macro need to change print areas based on Populated rows

How to print multiple print areas on the same page.

Print ranges based on cell value

[SOLVED] printing multiple print areas with a print dialog box

Tags for this Thread

Bookmarks

Bookmarks

Posting Permissions