| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Count merged cells
I have a form and when it loads I want it to calculate how many merged
cells are in selection. RnSz = Selection.Cells.MergeArea.Count - is what I thought it shoudl be but it keeps giving me Application-defined or object-defined error. I am not sure what this is telling me. Any help is appreciated, Jay |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Count merged cells
On Oct 8, 6:53*am, jlclyde wrote:
I have a form and when it loads I want it to calculate how many merged cells are in selection. RnSz = Selection.Cells.MergeArea.Count *- is what I thought it shoudl be but it keeps giving me Application-defined or object-defined error. *I am not sure what this is telling me. Any help is appreciated, Jay For those of you who are concerned, I found the answer. My current selection was through S1:AI9, so I had to resize it first. so it is now RnSz = Selection.resize(1,1).cells.mergearea.count. Sorry, Jay |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Count with 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 | |||
| Errors in COUNT, COUNTA, COUNTIF when counting merged cells | Excel Worksheet Functions | |||
| Sorting merged cellsHow do I sort merged cells not identically siz | Excel Worksheet Functions | |||
Linear Mode
