How to check for cells merged across rows

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
 
D

Dave Peterson

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
Help with merged cells 1
AutoFilter column w/merged cells 2
Insert rows and keep merged cells in the inserted row 1
How do I repeat a format of 2 merged cells to a number of rows in. 4
Merging Cells and Sorting 1

Top