About Us

Don Guillett

glad to help

--
Don Guillett
SalesAid Software

"lohme" wrote in message
...
Thanks - you and Don were a huge help!

"Pete_UK" wrote:

I would suggest this (based on Don's hideem):

Sub show_em()
Columns(1).SpecialCells(xlCellTypeBlanks).EntireRo w.Hidden = False
End Sub

Hope this helps.

Pete

lohme wrote:
Don, what is the command to unhide the rows? unhideem?

"Don Guillett" wrote:

to hide rows with blanks in col A

Sub hideem()
Columns(1).SpecialCells(xlCellTypeBlanks).EntireRo w.Hidden = True
End Sub

--
Don Guillett
SalesAid Software

"lohme" wrote in message
...
I want to automate the printing and I won't know how many blank rows
I'm
going to end up with each time.

"Don Guillett" wrote:

hide em

--
Don Guillett
SalesAid Software

"lohme" wrote in message
...
I want to print a worksheet where their are blank rows for future
use
between
the main body of the data and the total row. I want to exclude
the
blank
rows. How can I do this?

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Pivot Tables & not printing blank rows (revisited)	[email protected]	Excel Discussion (Misc queries)	1	August 4th 05 07:42 AM
Question regarding how to search a column and print a row(s)	Max	Excel Discussion (Misc queries)	0	July 15th 05 04:14 AM
How to delete blank rows	John Mansfield	Excel Discussion (Misc queries)	3	April 27th 05 11:48 PM
Insert rows	Mr. G.	Excel Worksheet Functions	3	March 31st 05 03:49 AM
Copy rows of data to another worksheet where ReturnDate is blank	Helen McClaine	Excel Discussion (Misc queries)	2	March 28th 05 11:33 PM