move cursor in excle using macro
hi
activecell.cut destination:=activecell.offset(2,0)
activecell.end(xldown).activate
but if the number of rows between the cut and paste is never the same, i
can't see how this will do much good other than show you the syntax.
Regards
FSt1
"fdibbins" wrote:
ok, sounds dumb, but how do I move the cursor in excel a set number of lines
using a macro - cant use a cell reference because it changes all the time. I
need to cut an item in 1 cell, move down 2 lines, past it and then "enddown"
to find the next instance. I have 100's of these to do, and number of lines
between each cut/paste is never the same. I know its really simple, but just
cant seem to get it working...help please!!!!
|