View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
APP OEU APP OEU is offline
external usenet poster
 
Posts: 2
Default How to check for cells merged across rows

In my spreadsheet, users are allowed to merge cells in a single
column, but not across rows.

How can I check (in VBA) that the selection contains either a single
cell, or a merged block in a column, and allow the process to
continue, but if the selection contains cells merged across rows,
then
present an error message and stop.


Many thanks.


APP OEU