Reference LastCol VB

I need to edit the following code so the formula does not go into "O"5 and "O"16, but into the last used col 5 and 16, then filldown.

Please Login or Register  to view this content.

Any ideas??

Maybe like this (untested)?

Please Login or Register  to view this content.

Well, It turns out that I have 2 columns to add formulas. I did some research and was able to set my lastcol variables and likewise add the formulas in the correct spots.
Here is what I have. It seems to work perfect.

Please Login or Register  to view this content.