Macro to select offset range

[erock24]

I am working on a macro that finds text then inserts an entire row and fills down formulas in col. H, J, N:BC into new row.
I have everything done up to N:BC. I need to copy those formulas down into the new line. I don't know how to select that range by offsetting. The macro ends on the new line at column N.
Here is my macro. If there is a better way to do what I have already done. please help.

Please Login or Register  to view this content.

Thank you very much for your time and help.

[erock24]

got it. A little more tricky but here it is.

Please Login or Register  to view this content.

[FrankBoston]

There is nothing wrong with your code, and there is a saying that any code that works is better than any code that doesn't. Since you solved your own problem, and published the results, I thought I would suggest what it could look like with some simplification, for your next project. I've been there myself.

In fact, there may be typos in the code below, because I haven't run it.

Please Login or Register  to view this content.

[erock24]

Thank you very much for your time. Your simplified version really sheds some light.