Add Row and Copy the Formula

[omegaboost]

Dear All,

Just need a help for the VBA script for select and copy the formula from certain range.
If we double click on column J then will add a new row below the active cell and will copy the function on column A until H on same row with the active cell, then will paste into 2 rows below active cell on column A until H.

For example: if we double click on J15, then will add new row below J15 also it will copy the function on range A15:H15. After that will paste formula into range A16:H17.

Thank you

Omega Boost

[alansidman]

try this:

Please Login or Register  to view this content.

[omegaboost]

Dear Alansidman,

Thank you for the respond, but actually I don't want to copy for the entire row just copy only the formula in column A until H.

[alansidman]

In your example there is no difference as the entire row consists of A:H. Is this not representative of your actual file? A true representation of your actual file is always encouraged as we are not mind readers. Upload a representative file and we will give you code that works for your example.