| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Unprinted cells
In the range of cells K40:R59, I do not want them to be printed. What would
the macro code be? |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Unprinted cells
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? |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Unprinted cells
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? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel: match two cells in one sheet to two cells in another and return a third cells value | Excel Worksheet Functions | |||
| compare 2 column cells and return the adjacent columns cells data of the cell | Excel Worksheet Functions | |||
| Cells won't change font color or show hi-lighted cells in document | Excel Discussion (Misc queries) | |||
| Skip cells with TAB/SHIFT+TAB but allow arrow keys/mouse selection of skipped cells | Excel Programming | |||
| trying to create an (almost) circular formula between cells and data validated cells with lists | Excel Worksheet Functions | |||
![Phil H[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Linear Mode
