Strooprover
New Member
- Joined
- Jul 21, 2017
- Messages
- 25
Hi All,
Probably a very easy question but I can't find the answer on the internet by myself.
I want to use a formula in different cells and the value has to adjust to the active cell.
This is the relevant part of my formula:
Now i want the R3C to be variable. So i thought up this:
Dim rng1 As Long
Rng1 = ActiveCell.Row
IF(ROWS(R3C:RC)>R1C6
Now I want my formula to work like this:
IF(ROWS(R(Rng1)C:RC)>R1C6
Probably no surprise for you guys but this doesn't work. Can someone show me how this should be written or if this isn't possible show me a approach to get the same result.
Much thanks in advance!
Gr.
Cees
Probably a very easy question but I can't find the answer on the internet by myself.
I want to use a formula in different cells and the value has to adjust to the active cell.
This is the relevant part of my formula:
Now i want the R3C to be variable. So i thought up this:
Dim rng1 As Long
Rng1 = ActiveCell.Row
IF(ROWS(R3C:RC)>R1C6
Now I want my formula to work like this:
IF(ROWS(R(Rng1)C:RC)>R1C6
Probably no surprise for you guys but this doesn't work. Can someone show me how this should be written or if this isn't possible show me a approach to get the same result.
Much thanks in advance!
Gr.
Cees