Use something like
If Range("A1").MergeCells Then
Do this
Else
Do something else
End If
--
Cheers
Nigel
"Dr. M" wrote in message
...
Hi all! I am looking to do something like this:
If mergecells=True
(then do one thing)
Else
(do something else)
Endif
But I cannot figure out how to get VB to work with my logic. Any ideas?
Thank you!