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.