View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Olly[_3_] Olly[_3_] is offline
external usenet poster
 
Posts: 10
Default 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