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