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

Thanks!

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!

You cannot hide specific cells. You can hide rows/columns or change font to
white for selected cells.

--
Don Guillett
SalesAid Software

"Heather" wrote in message
...
Please help me on how to hide specific cells when printing.

Thanks!