Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Copying cell contents from many cells and pasting into one cell | Excel Discussion (Misc queries) | |||
creating macro for copying the value from one cell | New Users to Excel | |||
Copying format to a new cell, w/o overwriting destination cell contents | Excel Discussion (Misc queries) | |||
copying the function contained within a cell to anouther cell. | Excel Worksheet Functions | |||
Question: Cell formula or macro to write result of one cell to another cell | Excel Programming |