Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Is cell outside printable area?
It there a way to check if a cell is outside the printable area?
Say, if the user set the printable area to columns A to G, and the macro find a value in a cell in column H. I would then like to mark that cell with a different background color - but only cells outside the printable area, which has contents. TIA, |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Is cell outside printable area?
Charlotte E pretended :
It there a way to check if a cell is outside the printable area? Say, if the user set the printable area to columns A to G, and the macro find a value in a cell in column H. I would then like to mark that cell with a different background color - but only cells outside the printable area, which has contents. TIA, Try looking at the Intersect() function: <air code If Not Intersect(cell, Range("Print_Area") Then 'shade it -- Garry Free usenet access at http://www.eternal-september.org ClassicVB Users Regroup! comp.lang.basic.visual.misc |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Is cell outside printable area?
On Fri, 3 Sep 2010 21:08:03 +0200, "Charlotte E" wrote:
It there a way to check if a cell is outside the printable area? Say, if the user set the printable area to columns A to G, and the macro find a value in a cell in column H. I would then like to mark that cell with a different background color - but only cells outside the printable area, which has contents. TIA, Go up in the upper left portion (the left edge) of the formula bar where the cell name or named range appears, and type in "Print_Area". When you enter a named range in that box, the screen jumps to that range. The current print area is always named that, so... type it in. |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Is cell outside printable area?
On Fri, 03 Sep 2010 15:13:06 -0400, GS wrote:
Charlotte E pretended : It there a way to check if a cell is outside the printable area? Say, if the user set the printable area to columns A to G, and the macro find a value in a cell in column H. I would then like to mark that cell with a different background color - but only cells outside the printable area, which has contents. TIA, Try looking at the Intersect() function: <air code If Not Intersect(cell, Range("Print_Area") Then 'shade it Cool. I see lots of possibilities with that function. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Copying printable area | Excel Worksheet Functions | |||
how can i extend the printable area up to the very last row | Setting up and Configuration of Excel | |||
printable area size | Excel Programming | |||
Set Printable area to skip columns | Excel Discussion (Misc queries) |