Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Finding Print Range
Hi,
I've been bouncing around researching this and it's just not coming together. Here's what I need to do. I have a range from E1:H90. However, below E9 I need to end the print range when I have 2 sequential empty cells. Here's the code I have so far: Sub PrintDoc1() ' ' PrintDoc1 Macro ' Dim LastRow As Long LastRow = Worksheets("Sheet1").Range("E9").End(xlDown).Row + 1 Range("E1:"&LastRow).Select Selection.PrintOut Copies:=1, Collate:=True End Sub 1. This doesn't work 2 How do I check for 2 sequential empty cells below E9? 3. How do I tell it to only print columns E through H? I would need this to work for whatever is the active worksheet. Thanks in advance. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Not finding file to print | Excel Programming | |||
Print Blank Pgs - Preview margins outside print range | Excel Discussion (Misc queries) | |||
Can you get the range reference for each page in a worksheet print range? | Excel Programming | |||
Finding the current "print range" | Excel Programming | |||
Excel 2000 VBA - Set Print Range in dynamic range | Excel Programming |