Ark68
Well-known Member
- Joined
- Mar 23, 2004
- Messages
- 4,564
- Office Version
- 365
- 2016
- Platform
- Windows
I am looking for some assistance on creating a vba solution to find the row values of first and last instance of a particular value in a dynamic range, assigning them to dstart and dend respectively.
The range is dynamic defined by "C" & pdaStart & "C" & pdaEnd. In our example, the range would be C13:C58.
The value we're looking for is "D"
With the above data capture, I am looking for the value of dstart = 13, and the value for dend = 32.
The range is dynamic defined by "C" & pdaStart & "C" & pdaEnd. In our example, the range would be C13:C58.
The value we're looking for is "D"
WS 24-May-22.xlsx | |||
---|---|---|---|
R | |||
12 | |||
13 | D | ||
14 | D | ||
15 | D | ||
16 | D | ||
17 | D | ||
18 | D | ||
19 | D | ||
20 | D | ||
21 | D | ||
22 | D | ||
23 | D | ||
24 | D | ||
25 | D | ||
26 | D | ||
27 | D | ||
28 | D | ||
29 | D | ||
30 | D | ||
31 | D | ||
32 | D | ||
33 | |||
34 | F | ||
35 | F | ||
36 | F | ||
37 | F | ||
38 | F | ||
39 | F | ||
40 | F | ||
41 | F | ||
42 | F | ||
43 | F | ||
44 | F | ||
45 | F | ||
46 | F | ||
47 | F | ||
48 | F | ||
49 | F | ||
50 | F | ||
51 | |||
52 | C | ||
53 | C | ||
54 | C | ||
55 | C | ||
56 | |||
57 | P | ||
58 | P | ||
59 | |||
Master |
With the above data capture, I am looking for the value of dstart = 13, and the value for dend = 32.