How to check for cells merged across rows

  • Thread starter Thread starter APP OEU
  • Start date Start date
A

APP OEU

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
 
See your early post.

APP said:
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
Click to expand...
 
Back
Top