Hello,
Here is a code below in which I want to change row number as per cell value find in the column A (Value = End)
First instance in column A "End" row number is 2 so far ABC = Range("B2:E2").Value
Second time in column A "End" row number is 10 so far ABC = Range("B10:E10").Value
And this way keep changing till last row numbers 2, 10, 14, 21, 28 and 36
For example the sample image is attached.
Kind Regards
Moti
Here is a code below in which I want to change row number as per cell value find in the column A (Value = End)
First instance in column A "End" row number is 2 so far ABC = Range("B2:E2").Value
Second time in column A "End" row number is 10 so far ABC = Range("B10:E10").Value
And this way keep changing till last row numbers 2, 10, 14, 21, 28 and 36
VBA Code:
Sub EndRowValue()
Dim ABC As Variant
ABC = Range("B2:E2").Value
End Sub
* | A | B | C | D | E |
1 | |||||
2 | End | ||||
3 | |||||
4 | |||||
5 | |||||
6 | |||||
7 | |||||
8 | |||||
9 | |||||
10 | End | ||||
11 | |||||
12 | |||||
13 | |||||
14 | End | ||||
15 | |||||
16 | |||||
17 | |||||
18 | |||||
19 | |||||
20 | |||||
21 | End | ||||
22 | |||||
23 | |||||
24 | |||||
25 | |||||
26 | |||||
27 | |||||
28 | End | ||||
29 | |||||
30 | |||||
31 | |||||
32 | |||||
33 | |||||
34 | |||||
35 | |||||
36 | End |
For example the sample image is attached.
Kind Regards
Moti