add
msgbox.target.address
in your code. This will let you know how excel sees the merged cell.

For selection change:
address = "$C$7:$E$7"

see if that doesn't help...
--
steveB

Remove "AYN" from email to respond
"chris100" wrote in
message ...

SteveB,

Works like a charm but for one thing, the actual cell i want to use
this on is a merged cell (C7-E7) and so for the code you wrote doesn't
work.
Is there a way around this? i notice it runs through part of the
operation but not all of it.

regards


--
chris100
------------------------------------------------------------------------
chris100's Profile:
http://www.excelforum.com/member.php...o&userid=25166
View this thread: http://www.excelforum.com/showthread...hreadid=388140