| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How to check for cells merged across rows
See your early post.
APP OEU wrote: 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 -- Dave Peterson |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to check for Horizontally merged cells | Excel Discussion (Misc queries) | |||
| Seperate Merged Cells with multiple rows? | Excel Discussion (Misc queries) | |||
| Blank Rows from Merged Cells in Drop Down Menu | Excel Discussion (Misc queries) | |||
| identically size merged cells for sorting rows | Excel Discussion (Misc queries) | |||
| Rows with merged cells are not adjusting even w/ Wrap Text and au. | Excel Discussion (Misc queries) | |||
Hybrid Mode
