Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Single Row to Multiple Row Determination
I have an excel spreadsheet feed that, for any row A may cover multiple rows
of B. How do I determine programmatically the range of B rows that are included "within" row A1? (I will be merging all the text contained in the B rows into one cell for each value of A.) The data is arranged similar to the following; A1 B1 B2 B3 B4 A2 B5 B6 A3 B7 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Single Row to Multiple Row Determination
I'm not exactly sure what you're doing, but you could try doing something
like this Dim r as Range for each r in ActiveSheet.UsedRange if r.mergearea.count 1 then Debug.print r.mergearea.address end if next r "Jim" wrote: I have an excel spreadsheet feed that, for any row A may cover multiple rows of B. How do I determine programmatically the range of B rows that are included "within" row A1? (I will be merging all the text contained in the B rows into one cell for each value of A.) The data is arranged similar to the following; A1 B1 B2 B3 B4 A2 B5 B6 A3 B7 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Sumproduct, single criteria identified within multiple in single c | Excel Discussion (Misc queries) | |||
Printing single pages from multiple worksheets in a single print job | Excel Discussion (Misc queries) | |||
Find Multiple instances of Single Criterion in Row & Return To a Single Col | Excel Worksheet Functions | |||
Earned Value Determination | Excel Discussion (Misc queries) | |||
Average determination | Excel Worksheet Functions |