I have a formula in cell A1 and text in either cell B2 or C2. This text continues down the rows until there is no text in either columns B or C.
I wish to copy the formula in A1 into A2 and then continue copying down column A until both cells in column B and C are empty. What is the excel VBA code?
Thanks Sandy.
Bookmarks