View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Richard[_20_] Richard[_20_] is offline
external usenet poster
 
Posts: 16
Default Nesting a formula in a macro

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.