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