"Biff" wrote:
The link suggested by Max isn't a good reliable solution in your case
because the cells are being colored by conditional formatting. ...

... and how was this* evident based on what was posted by the OP <g ?
*..cells are being colored by conditional formatting..
--
Rgds
Max
xl 97
---
GMT+8, 1° 22' N 103° 45' E
xdemechanik <atyahoo<dotcom
----