I have a range F5:F356, that has a formula in each cell.
I'd like to loop through range F4:EX4, and for each cell that is 0>, drag the formulas over.
Example:
Values:
F4 = 12345
G4 = 45643
H4 = 45640
I4 = 98765
J4 = 65475
K4-EX4 = 0
I'd like to autofill the formulas from the F5:F356 range, through J5:J356, because every cell through J4 is 0>
I know how to do the loop part using (for each c in range). It's the autofill issue, based on cell value i need help with. I'm assuming I need to use something like activecell, active column, etc somehow.
thanks!!!
I'd like to loop through range F4:EX4, and for each cell that is 0>, drag the formulas over.
Example:
Values:
F4 = 12345
G4 = 45643
H4 = 45640
I4 = 98765
J4 = 65475
K4-EX4 = 0
I'd like to autofill the formulas from the F5:F356 range, through J5:J356, because every cell through J4 is 0>
I know how to do the loop part using (for each c in range). It's the autofill issue, based on cell value i need help with. I'm assuming I need to use something like activecell, active column, etc somehow.
thanks!!!