Hi!,

Firstly, thanks for taking time to help me.

I understand that there are many places to go look for the code to drag down formulas to the last empty cell and stuff like that. I need something that will drag formulas down based on the value of a variable defined in the code. So this variable can be of any value from 1 to 1000.

Hope my explanation is clear.

Thank You!