Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Set Print Area with Dynamic Start Point
I want to test a row for a date, for the start cell, for the print area.
Using that cell as a start, select 11 more columns, and 44 rows to set the print area. Sub Test1 () Range("G17").Select Do While ((ActiveCell) < Range("B4")) ActiveCell.Offset(0, 1).Select If ((ActiveCell) = Range("D2")) Then Exit Do End If Loop 'SET PRINT AREA ((First cell of print area would be the cell the loop stops on. Then down 44 row and over 12 columns)) ActiveSheet.PageSetup.PrintArea = SOME CODE ActiveWindow.SelectedSheets.PrintPreview End Sub |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Dynamic Print Area | Excel Programming | |||
Dynamic Print Area | Excel Programming | |||
Dynamic Print Area | Excel Discussion (Misc queries) | |||
dynamic print area | Excel Worksheet Functions | |||
select dynamic range with dynamic start point | Excel Programming |