OK. The file has been posted. Now your original query was

++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
These formulas, paste  it horizontally and then see how does the formulas  flow
Please help  me in this regards to automatically  generate it for the multiple
rows.





=IF(J11<=0,"",IF(E11<=0,"",(J11/E11-1)))


=IF(K11<=0,"",IF(F11<=0,"",(K11/F11-1)))


=IF(L11<=0,"",IF(G11<=0,"",(L11/G11-1)))

... etc.
++++++++++++++++++++++++++++++++++++++++ end of quote

I cannot understand what you want or where it relates to the file.

Which cell do you want the formula  =IF(J11<=0,"",IF(E11<=0,"",(J11/E11-1)))
in?

Why do you want to generate  these formulas with VBA rather than putting them
in the spreadsheet in the design stage?

What has pasting horizontally got to do with it?

I would rather help you achieve your objective than help you solve problems
which arise because you are trying to do something irrelevant or impossible.
Tell me what the end result is supposed to be.