Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Merged Cells
Hello
How can I find out if a range contains merged cells? I think that it is not very powerful to check each cell if the MergeCells property is true? Any faster ideas? Many thanks in advance. Tom |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Merged Cells
Tom,
Cell by cell is the only way. AFAIK. A better solution is to never use merged cells. HTH, Bernie MS Excel MVP "Tom" wrote in message ... Hello How can I find out if a range contains merged cells? I think that it is not very powerful to check each cell if the MergeCells property is true? Any faster ideas? Many thanks in advance. Tom |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Merged Cells
thx
"Bernie Deitrick" <deitbe @ consumer dot org schrieb im Newsbeitrag ... Tom, Cell by cell is the only way. AFAIK. A better solution is to never use merged cells. HTH, Bernie MS Excel MVP "Tom" wrote in message ... Hello How can I find out if a range contains merged cells? I think that it is not very powerful to check each cell if the MergeCells property is true? Any faster ideas? Many thanks in advance. Tom |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Copy paste non merged to merged cells | Excel Worksheet Functions | |||
How can I sort an Excel Doc containing merged & non-merged cells? | Excel Discussion (Misc queries) | |||
Autofit Merged cell Code is changing the format of my merged cells | Excel Discussion (Misc queries) | |||
how do i link merged cells to a merged cell in another worksheet. | Excel Worksheet Functions | |||
Sorting merged cellsHow do I sort merged cells not identically siz | Excel Worksheet Functions |