Autofill till cell "x"
 

Is there a way to auto fill a formula or a value all the way down of a column
till it finds the value "x" and stop on the cell above the cell with the
value "x" in that column? This would really help me out. Thanks!

Autofill till cell "x"
 

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

Autofill till cell "x"
 

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