View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Bruce Roberson[_5_] Bruce Roberson[_5_] is offline
external usenet poster
 
Posts: 6
Default 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