FORMULAR INSERTION

[Kanmi]

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.

 

[Jacob Skaria]

Try the below
Range("E3:E135").Formula = cstr(Range("E1"))

If this post helps click Yes

 

[Kanmi]

Hello Thanks. Where is the formular. i need to use this
formular"(=365/(M3/N3)". Thank you for your time.

 

[Jacob Skaria]

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