Copying a cell to another cell using a macro

  • Thread starter Thread starter Olly
  • Start date Start date
O

Olly

I need a way of pasting the cell bellow the line of cells that already
has text in them, like the code bellow.

However I need the code to check the B column instead of the one
directly above the cell that I am pasting in to.

Sheets("Order Input Forum").Range("A13").Copy _
Sheets("Order Records").Cells(Rows.Count, "C").End(xlUp)(2, 1)
Application.CutCopyMode = False

Thanks
Olly
 
Hi Olly

If I understand you correct then try this

Sheets("Order Records").Cells(Rows.Count, "B").End(xlUp).Offset(1, 1)
 
Back
Top