Nesting a formula in a macro
I'm confused: if COUNT(I2:I100) = 10, say, what would
R = Range("=COUNT(I2:I100)").Value
or
R = Range(10).Value
or
R = Range(Range("L1").Formula).Value
represent?
In article ,
"Richard" wrote:
I have the following at the beginning of a macro:
R = Range("L1").Value
Is there a way to replace "L1" by the formula used in L1
itself.
Before excecuting the macro I put the following formula in
L1: =COUNT(I2:I100).
Basically, is it safe to directly replace ("L1") by its
formula?
Thanks for any help.
|