View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.programming
Nigel Nigel is offline
external usenet poster
 
Posts: 923
Default If Statement: How to test if a cell is merged or not?

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!