Sum with dynamic cells
-
Natit1 -
June 8, 2021 at 8:37 AM -
Thread is marked as Resolved.
-
-
-
-
If you're trying to put a formula in there, you need the address of the range:
or just:
If you just want the value, then:
-
Sorry, but it doesn't work
The sheet is attached here.
-
Sorry, I answered to fast.
The second option worked great
this one - (Range("r1").FormulaR1C1 = "=sum(R1C1:R" & Lrow & "C" & Lcol & ")")
-
Participate now!
Don’t have an account yet? Register yourself now and be a part of our community!