Add text in am macro bellow the already entered text

O

Olly

Useing this code how can i get it to post the new text bellow the
already entered text:

Sheets("Order Input Forum").Range("A13").Copy _
Sheets("Order Records").Range("C4")
Application.CutCopyMode = False

Thanks
Olly
 
C

Chip Pearson

Olly,

Try something like

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


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com
 
Top