ExcelBanter - Unprinted cells

ExcelBanter (https://www.excelbanter.com/)

- Excel Programming (https://www.excelbanter.com/excel-programming/)

- - Unprinted cells (https://www.excelbanter.com/excel-programming/369097-unprinted-cells.html)

In the range of cells K40:R59, I do not want them to be printed. What would
the macro code be?

Basically, this isn't supported (omitting cells within a larger print area) -
so you would have to look for workarounds.

If you want to print everything around them, then you would have to cover
them with an opaque rectangle. Or link another sheet to the cells on that
sheet this sheet would layout your data the way you want to see it - then
print this dummy sheet.

--
Regards,
Tom Ogilvy

"Phil H" wrote:

In the range of cells K40:R59, I do not want them to be printed. What would
the macro code be?

Of course you could change the font color to match the background color - but
some printers will recognize this inconsistency and compensate for it - so
such an approach may not be reliable.

--
Regards,
Tom Ogilvy

"Phil H" wrote:

In the range of cells K40:R59, I do not want them to be printed. What would
the macro code be?