Does anybody know how to create the fill effect on Column B starting at cell 2 and going until there are no more values left in Column A in a macro.