How to print a name range using check boxes

[ABabeNChrist]

I was wondering how I might use a name range to print using check boxes.
At the present moment I use this method to print.

Code: Select all

If CheckBox4.Value = True Then
     Sheets("Grounds").Select
    ActiveWindow.SelectedSheets.PrintOut Copies:=1, Collate:=True
    End If
    If CheckBox7.Value = True Then
     Sheets("Roof").Select
    ActiveWindow.SelectedSheets.PrintOut Copies:=1, Collate:=True
    End If
   End Sub

[mbarron]

You can use:

Code: Select all

Range("myRangeName").PrintOut Copies:=1, Collate:=True

[ABabeNChrist]

Hi mbarron
That was easy enought
it worked FANTASIC
Thank you so much

Code: Select all

Range("myRangeName").PrintOut Copies:=1, Collate:=True

[/quote]

[GeoffW]

Use of "Select" does slow down VBA execution, especially where used frquently.

Many times it can be coded out, but the trouble is that many people start by recording macros and using the generated code- and this often involves selecting.