Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
In a macro that checks for a number of errors and sets the zoom, print range,
and page breaks for each worksheet, I'm getting this error on the Set rngLast line: For Each wrksht In ActiveWorkbook.Worksheets With wrksht .Activate intLastRow = GetLastRow() If intLastRow < 0 Then ' Reset zoom and view With ActiveWindow .View = xlNormalView .Zoom = intZoom End With ' Assign print range and set page breaks Set rngLast = Cells(intLastRow, fintHeaderColumn()) .PageSetup.PrintArea = "$A$1:" & rngLast.Address Call SetPageBreaks(intLastRow) Does anyone know why? Sprinks |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Application-Defined or object defined error 1004 When ran on exel97 but not 2003 | Excel Programming | |||
Runtime error 1004- application defined or object defined erro | Excel Programming | |||
Runtime error 1004- application defined or object defined erro | Excel Programming | |||
Runtime error 1004- application defined or object defined erro | Excel Programming | |||
Macro Run-time Error 1004 Application Defined or Object Defined Error | Excel Programming |