Quote Originally Posted by icestationzbra View Post
for pete's sake , instead of A:A, use A5:A100 (or however far data stretch in column A)...

do not worry about changing the 'ROWS(A$1:A1)' portion of the formula.
I tried that it breaks it. Then all it does is copy line for line it doesn't repeat.