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...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How to check for Horizontally merged cells 1
Sharing workbooks limitations - Merged Cells 12
Auto Row Height with Wrapped Text in Merged Cells Problem 3
Merge Cells- A challenge! 1
Center across selection 2
AutoFilter column w/merged cells 2
Merging Cells and Sorting 1
Insert rows and keep merged cells in the inserted row 1

Back
Top