You can only hide entire rows or entire columns or both - but you can't hide
an individual cell.

Assume you want to hide all rows in column A that are blank

rows.Hidden = False
On error Resume Next
set rng = columns(1).specialCells(xlBlanks)
On Error goto 0
if not rng is nothing then
rng.EntireRow.Hidden = True
End if
Activesheet.Printout
rows.Hidden = False

--
Regards,
Tom Ogilvy


"Heather" wrote:

Please help me on how to hide specific cells when printing.

Thanks!