Unpopulated Cell Address

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Mick Smith - 18 Jul 2007 21:52 GMT

Hi
I'm a newbie and was wondering can anyone help with my query.
I am trying to find out how to print a spreadsheet with just the data that
is contained in certain cell address's.

Where a cell address is not populated I want the whole row to not appear in
a printed copy.

Any ideas?

Reply to this Message

Don Guillett - 18 Jul 2007 23:42 GMT

Try this idea

Sub hiderowsandprint()
With Range("a1:a21")
.SpecialCells(xlCellTypeBlanks).Rows.Hidden = True
.Resize(21, 8).PrintPreview
.Rows.Hidden = False
End With
End Sub

Signature

Don Guillett
Microsoft MVP Excel
SalesAid Software
dguillett1@austin.rr.com

> Hi
> I'm a newbie and was wondering can anyone help with my query.
[quoted text clipped - 6 lines]
>
> Any ideas?

Reply to this Message

Rate this thread: