Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Selecting a range composed of current region + 2 rows
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Selecting a range composed of current region + 2 rows
Hi Bruce,
one way Dim oRng As Range Set oRng = Range("Start").Offset(3, 0).CurrentRegion oRng.Resize(oRng.rows.Count + 2, oRng.columns.Count).PrintPreview -- HTH RP "Bruce Roberson" wrote in message ... 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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Selecting a range composed of current region + 2 rows
Very good Bob, thanks once again.
Bruce -----Original Message----- Hi Bruce, one way Dim oRng As Range Set oRng = Range("Start").Offset(3, 0).CurrentRegion oRng.Resize(oRng.rows.Count + 2, oRng.columns.Count).PrintPreview -- HTH RP "Bruce Roberson" wrote in message ... 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 . |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
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 |