View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Harlan Grove Harlan Grove is offline
external usenet poster
 
Posts: 733
Default Script doesn't work when cells are merged.


wrote...
....
Looking at the script below, when cell A1 is merged with another cell, the
script doesn't work.


Helps if you mention how it doesn't work.

How do i make it work, (irregardless wether its merge or not)


What are you trying to do? Merged cells interact oddly with event
handlers. If you make an entry into a merged cell, the Target range
passed to the event handler is the single top-left cell of the merged
range. However, if you CLEAR a merged cell, the Target range passed to
the event handler is the entire merged range. PITA.