Hi Tom,

I know its been a while on this query, but Im only getting to look at
the answer your proposed now. Good news is it works, BUT only if you
selec the exact cell which is the problematice one (ie the merged one)
How can I get it to run for all cells... ie look at all cells, and IF
its a merged one then run the macro...?

Really really appreciate your help.

Kind regards

Darin



*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!