Help with copying a formula up a row

Hello All:

I am stuck with some code here. I have recorded a macro that will copy a row (8 colswide) and drag it the formula up over 200+ rows. The code is below:

Please Login or Register  to view this content.

I would like to replace the relative references w/ variables that I have already created, I am just having trouble putting them in the recorded macro code. Instead of

Please Login or Register  to view this content.

I would like it to offset by the variable (-xRowNeeded). I want to drag the formula up whatever the amount 'xRowNeeded' is. I know I will need to change the

Please Login or Register  to view this content.

parts as well which I unfortunately could use some help with too. Any help is greatly appreciated. Thanks everyone!