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.