Home |
Search |
Today's Posts |
#5
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Here is my full code??? Is it one of the other lines that could be
screwing it up? Sub PrintFormat() ' ' ' VB Created 10/17/2007 ' ' Updates Autofilter Selection.AutoFilter Field:=61, Criteria1:="2" ' Widens rows as necessary Rows("4:1000").EntireRow.AutoFit Application.CutCopyMode = False ' Sets Print Area Dim lastCell As Range Set lastCell = Cells.SpecialCells(xlCellTypeLastCell).Offset(1, 0) Do Until Application.Count(lastCell.EntireRow) < 0 Set lastCell = lastCell.Offset(-1, 0) Loop ActiveSheet.PageSetup.PrintArea = Range(Cells(1, 1), lastCell).Address ' End Sub |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Prevent getting all rows if Autofilter criteria doesn't exist | Excel Programming | |||
Selection.AutoFilter Field / Criteria = criteria sometimes non-existing on worksheet | Excel Programming | |||
Error Handling - On Error GoTo doesn't trap error successfully | Excel Programming | |||
3 criteria must exist in adjoining cells then rtn val from 4th | Excel Discussion (Misc queries) | |||
Error handling with a handling routine | Excel Programming |