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,

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

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.

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.