Automate Formula for each row

Dear Members,

I have a Scenario where in the Sheet 1 columns (N, O, P, Q, R) have formulas.
How do i create a VBA script which will help copy all the formualas to each row..

There are only 18 rows, but in future it may grow to lakhs..
SO how do we convert this formula to VBA code & then Paste special it.. so that after execution the Formulas will not be seen.. Only values... Please suggest.

Attaching the sample file where Cloumns(N, O, P, Q, R) needs to be automated

Below is the Sample code recorded macro

Please Login or Register  to view this content.

Here is the simple workaround.
1. Put Formulas in First row manually.
2. Then Use this Little code to autofill

HTML Code: 

HI Vikas,

Cant we automate first row too? Coz it will be difficult to everytime write formula in row 1 & then running the code & then again Paste special all formulaes...

Perfectly worked.. thanks for sharing the code

Originally Posted by ufopilot

Attachment 380356

I'm no guru, but This will fill formulas down to the last row of input (depending on column A)
and then have them set as values only.

It's rough, and I'm sure it could be wrote smoother, but it works.
Hope it helps

Okay then try this...

HTML Code: 

Solved.. Great .. Vikas.. thanks for sharing...