hi all - i thought this code would loop through the range and put a formula in every box ... but it doesn't. how can it be changed to make it loop?
if it is possible, can the code just loo for Z00 rather than Z004.... i could use that to fill the rest of the column rather than have separate codes for each....
thank you
Code:
With Range("E2:E100").Find("Z004").Offset(0, 10)
.Value = "=((K3*M3)/N3)"
End With
if it is possible, can the code just loo for Z00 rather than Z004.... i could use that to fill the rest of the column rather than have separate codes for each....
thank you