Unpopulated Cell Address

  • Thread starter Thread starter Mick Smith
  • Start date Start date
M

Mick Smith

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?
 
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
 
Back
Top