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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Having difficulty copying and pasting on VBA 3
Change a great number of words in word files, with a macro as short as possible. 5
Macro stops running if date is not in past... 3
Copying a cell to another cell using a macro 1
Adjusting the layout of over 1000 existing Word documents using a macro-driven batch run 0
Macro to Select text from a point given to a specific word 2
Finding the proper style field and the numbered paragraph value within the style 0
Finding the right style field in VBA 0

Top