Copying a cell to another cell using a macro
 

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

Copying a cell to another cell using a macro
 

Hi Olly

If I understand you correct then try this

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


--
Regards Ron de Bruin
(Win XP Pro SP-1 XL2002 SP-2)
www.rondebruin.nl



"Olly" wrote in message om...
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