Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to Avoid Printing Blank Rows
Hi All,
How do i avoid printing blank rows in a Selected Range of cells using VBScript. Thank you, |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to Avoid Printing Blank Rows
Dim rng as range
On error resume Next set rng = Selection.Specialcells(xlBlanks) On error goto 0 if not rng is nothing then rng.EntireRow.Hidden = True Selection.Printout if not rng is nothing then rng.EntireRow.Hidden = False -- Regards, Tom Ogilvy Yogesh wrote in message ... Hi All, How do i avoid printing blank rows in a Selected Range of cells using VBScript. Thank you, |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Avoid Printing the Combo Box with the Chart | Charts and Charting in Excel | |||
how can avoid considering of blank cells in IF function | Excel Worksheet Functions | |||
Pivot Tables & not printing blank rows (revisited) | Excel Discussion (Misc queries) | |||
Pivot Tables & not printing blank rows (revisited) | Excel Worksheet Functions | |||
How can I avoid a BLANK cell being interpreted as a ZERO? | Excel Programming |