Go to a cell automatically

Don Guillett · Oct 3, 2003

try
range("b1").end(xldown).offset(1).paste

Ron de Bruin · Oct 3, 2003

Try this

Range("d1").Copy Range("b1").End(xlDown).Offset(1)

Mercury · Oct 3, 2003

How can I make the active cell the cell after the statement:
"End("B1").xlDown.offset(1,0)" to start a paste operation.

Thanks in advance.