Thanks, but not really what I was looking for. Besides, I don't know VBA
coding.

"Susan" wrote:

i'm still learning, but i've used the "x" trick sometimes to tell a
macro when to stop.
in this case, you could loop thru & check each cell for the "x".
something like:

sub copypaste()

copy("b3") ' or whatever cell you want
range.offset (0,1)

'in my experience, autofill is the same
'as copy in that the cell references
'change.

do
if activecell=("x") then
exit sub
else
paste
range.offset (0,1)
end do

end sub

warning - don't copy this!!!! :) it's just an idea. the syntax is
probably all wrong - i'd have to look it all up myself to make it work
right, but perhaps the idea will get you started.
susan