Fill formulas to last row containing data.

[AnthonyWB]

Hello everyone. I would like to extend the fomulas in columns AP, AQ, and AT to the last row of data. Currently I paste (via a macro) data from two seperate files into a workbook that acts as a template where the formulas in columns AP, AQ and AT are extended "far down". I would like to stop doing that and simply extend the formulas via code. Any suggestions? Below is my code that I am working with. The formuals are extended in the worksheet called "...Valuation Tool"

Please Login or Register  to view this content.

[AnthonyWB]

This is somewhat modified from another post. Any other suggestions?

Please Login or Register  to view this content.

[AnthonyWB]

Correction:

Please Login or Register  to view this content.

[AnthonyWB]

Anyone have any ideas on this?

[AnthonyWB]

I got it !