Add text in am macro bellow the already entered text

  • Thread starter Thread starter Olly
  • Start date Start date
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
 
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
 
Back
Top