sous2817
Well-known Member
- Joined
- Feb 22, 2008
- Messages
- 2,276
Hello everyone,
I have a report that is in this general format:
Can someone show me a way to loop through the used rows and define the range(s) between the "Test"s? So in the above example, there would be 4 named ranges "Test1" would be B6:B9, Test2 would be B11:B13, Test3 would be B15:B24, etc, etc, etc.
Any help would be greatly appreciated.
I have a report that is in this general format:
Book1 | ||||||
---|---|---|---|---|---|---|
A | B | C | D | |||
5 | Test1 | |||||
6 | Data | |||||
7 | Data | |||||
8 | Data | |||||
9 | Data | |||||
10 | Test2 | |||||
11 | Data | |||||
12 | Data | |||||
13 | Data | |||||
14 | Test3 | |||||
15 | Data | |||||
16 | Data | |||||
17 | DAta | |||||
18 | Data | |||||
19 | Data | |||||
20 | DAta | |||||
21 | Data | |||||
22 | Data | |||||
23 | DAta | |||||
24 | Data | |||||
25 | Test4 | |||||
26 | Data | |||||
27 | Data | |||||
28 | Data | |||||
Sheet1 |
Can someone show me a way to loop through the used rows and define the range(s) between the "Test"s? So in the above example, there would be 4 named ranges "Test1" would be B6:B9, Test2 would be B11:B13, Test3 would be B15:B24, etc, etc, etc.
Any help would be greatly appreciated.