FORMULAR INSERTION
Hi Kanmi
Your formula in E1 as mentioned in your post
'In E1(cell formatted as text)
=365/(M3/N3)
'Within your code OR from immediate window try
Range("E3:E135").Formula = Cstr(Range("E1"))
If this post helps click Yes
---------------
Jacob Skaria
"Kanmi" wrote:
Hello Thanks. Where is the formular. i need to use this
formular"(=365/(M3/N3)". Thank you for your time.
"Jacob Skaria" wrote:
Try the below
Range("E3:E135").Formula = cstr(Range("E1"))
If this post helps click Yes
---------------
Jacob Skaria
"Kanmi" wrote:
Hello, Please can anybody help me with this.
i want to put this formular on cell "E1" (=365/(M3/N3) and i want the
formular to apply to FROM "E3:E135". I want the formular to be on E1.
Please how can i go about this. God bless you as you take your time to ans
this. Thanks.
Note: There are Title on E2.
i want to be able to edit contents of E3:E135.
Thanks one more time and God bless.
|