none
CopyPaste ActiveCell to ActiveCell.Offset(0,7) RRS feed

  • Question

  • I want to select ActiveCell (using For i command), and copy all cells to ActiveCell.Offset(0,7).

    Smoething like this;

    X = ActivCell : ActiveCell.Offset(0,7)

    x.Copy

    ActiveCell.Offset(1,0).Paste

    Saturday, February 18, 2017 2:44 PM

All replies

  • Perhaps

    ActiveCell.Resize(ColumnSize:=7).Copy Destination:=ActiveCell.Offset(RowOffset:=1)


    Regards, Hans Vogelaar (http://www.eileenslounge.com)

    • Proposed as answer by ryguy72 Monday, February 20, 2017 3:57 PM
    Saturday, February 18, 2017 3:03 PM