Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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! |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
addera 1 till cell "automatiskt" | Excel Discussion (Misc queries) | |||
Excel - Golf - how to display "-2" as "2 Under" or "4"as "+4" or "4 Over" in a calculation cell | Excel Discussion (Misc queries) | |||
Help!!! Enter "7" in a cell and Excel changes the "7" to "11" immediately!!! | Excel Discussion (Misc queries) | |||
Complex if test program possible? If "value" "value", paste "value" in another cell? | Excel Discussion (Misc queries) | |||
autofill or copy & paste "till a value" | Excel Programming |