| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Print Range Question
I am trying to develp a macro that will set the Print Range in a worksheet. I
have tried to modify several macos on the forums with no success. The problem is I need to count down to the bottom of column A (which does contain some blanks), to the first row that contains 0. Then I want the macro to set the Print Range to A1:FX, where X is equal to the last row before the 0. Thanks in advance! (Using Excel 2003) |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| 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 | |||
| Range Question / error 1004: method Range of object Worksheet has failed | Excel Programming | |||
| Excel 2000 VBA - Set Print Range in dynamic range | Excel Programming | |||
| Range.Formula and Range question using Excel Automation | Excel Programming | |||
Threaded Mode
