Hi
I have a formula in cell A1 a which is locked. When I enter a value I into B1, I want the formula to AutoFill down to A2, when I put a value into B2 I want to formula to autofill down to A3 etc...... Is it possible through VBA worksheet code to handle this?
thanks
Bookmarks