Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
The range below selects a contigous region 3 rows below
the one cell range called "start". But what if I want the print area to include not only that area, but I need it to skip a blank line and then include the totals which reside in the following row. I do not want to eliminate the blank line to make this work. Range("Start").Offset(3, 0).CurrentRegion.PrintPreview I should know how to do this by now, but I it is late in the day and I am stuck at the moment. Thanks, Bruce |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Current region emulation | Excel Worksheet Functions | |||
Copy Current Region | Excel Programming | |||
Naming Current Region | Excel Programming | |||
Trying to convert a used range into a current region | Excel Programming |