Hi All,

Does anybody have the code to determine if the ActiveCell is within a range
of columns ie F:CZ ?

I think l should be able to use the Intersect function if l state the full
range (ie F6:CZ5006) but have had no luck so far.

For various reasons l cannot restrict the selection of cells by locking and
using = xlUnlockedCellsOnly using the worksheet activate event.

All help / suggestions gratefully received

Regards

Michael Beckinsale