Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
counting colored cells when merged
This worksheet counts elements based on the cell color. Thanks to Pearson
Software Consulting / xlDynamic I've cleared the first hurdles. Was able to get the rest of the process to work fine EXCEPT I'm using merged cells for graghical representation purposes. I'm failing to develop a practical strategy to compensate for these varying multi-cell elements. For clarity I have a situation as this. One {part of a} unit consists of eight elements. Element 1 consists of merged cells A1:B1; Element 2 - A2:B2; Element 3 - C1:E2, Elements 4 through 8 - A3 to E3 respectively. Guess I'm ultimately asking, is there a way to code (count) the merged cells as a single unit as opposed to counting the individual cells that comprise them? I have one strategy, but it is very cumbersome / inflexible and the project requires a little more flexibility to be practical. Any suggestions would be most welcome. T-I-A... |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
counting colored cells when merged
Hi
Maybe some kind of test like: If Selection.MergeCells Then Nb = 1 would suit your needs? HTH Cordially Pascal "DrKilbert" a écrit dans le message de ... This worksheet counts elements based on the cell color. Thanks to Pearson Software Consulting / xlDynamic I've cleared the first hurdles. Was able to get the rest of the process to work fine EXCEPT I'm using merged cells for graghical representation purposes. I'm failing to develop a practical strategy to compensate for these varying multi-cell elements. For clarity I have a situation as this. One {part of a} unit consists of eight elements. Element 1 consists of merged cells A1:B1; Element 2 - A2:B2; Element 3 - C1:E2, Elements 4 through 8 - A3 to E3 respectively. Guess I'm ultimately asking, is there a way to code (count) the merged cells as a single unit as opposed to counting the individual cells that comprise them? I have one strategy, but it is very cumbersome / inflexible and the project requires a little more flexibility to be practical. Any suggestions would be most welcome. T-I-A... |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
counting colored cells when merged
Appreciate the tip; Been away from this stuff too long, but you've
stimulated what I know I need to do. Have used flags all my life... Still know it's going to require some detailing... Anyway, thanks. "papou" wrote: Hi Maybe some kind of test like: If Selection.MergeCells Then Nb = 1 would suit your needs? HTH Cordially Pascal "DrKilbert" a écrit dans le message de ... This worksheet counts elements based on the cell color. Thanks to Pearson Software Consulting / xlDynamic I've cleared the first hurdles. Was able to get the rest of the process to work fine EXCEPT I'm using merged cells for graghical representation purposes. I'm failing to develop a practical strategy to compensate for these varying multi-cell elements. For clarity I have a situation as this. One {part of a} unit consists of eight elements. Element 1 consists of merged cells A1:B1; Element 2 - A2:B2; Element 3 - C1:E2, Elements 4 through 8 - A3 to E3 respectively. Guess I'm ultimately asking, is there a way to code (count) the merged cells as a single unit as opposed to counting the individual cells that comprise them? I have one strategy, but it is very cumbersome / inflexible and the project requires a little more flexibility to be practical. Any suggestions would be most welcome. T-I-A... |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
counting colored cells | Excel Discussion (Misc queries) | |||
Counting colored cells | Excel Worksheet Functions | |||
Counting cells with colored font | Excel Worksheet Functions | |||
Counting colored cells | Excel Discussion (Misc queries) | |||
counting colored cells | Excel Discussion (Misc queries) |