VBA - FillDown Formulas based on # of Rows in Column B

[sighlent1]

Hello,

Any help with this is greatly appreciated.

Sincerely, thank you so much,
Robert


I have values in Column B, and formulas in C2:I2, which transpose the values in Column B.

Before.png


I currently have a macro that will Filldown the formulas in C2:I2 down to the last Row in Column B.

After Formula Filldown.png


Unfortunately, this led to meaningless zero's in my Range that I've been having to remove via another macro, which runs extremely slow.


The Rows in Column B will ALWAYS be divisible by 4.
Ideally, I would like to Filldown the formulas in C2:I2 1 quarter of the way down of Column B.

Could you please write something in VBA that would do this for me?


So, if Column B has 40 Rows, Filldown Formulas 10 Rows.
Or, if Column B has 32 Rows, Filldown Formulas 8 Rows.

Ideally After Filldown number of rows divided by 4.png

This should remove that horribly slow macro that I'd have to run to get rid of the zeros.

[TMS]

You don't necessarily need VBA. You could just adjust your formula.

Please Login or Register  to view this content.

[sighlent1]

This is sooo MUCH FASTER!!


I think this is the best solution considering my circumstances

Thank you so much!

[TMS]

You're welcome. Thanks for the rep.

[TMS]

If you need a macro, then maybe this:

Please Login or Register  to view this content.

[sighlent1]

I appreciate this alternative!

Thank you!!

[TMS]

Not so much an alternative as a quick way of dropping the formulae in.