| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
cell copying
Example for column A
Sub copytest() Range("A" & Rows.Count).End(xlUp).copy _ Range("A" & Rows.Count).End(xlUp).Offset(1, 0) End Sub -- Regards Ron de Bruin http://www.rondebruin.nl "marcde" wrote in message ... I want to write a macro which searches for the last cell in a colum and copy this cell to the next cell below, each time the macro is performed. |
| 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) | |||
| Copying format to a new cell, w/o overwriting destination cell contents | Excel Discussion (Misc queries) | |||
| Copying color formatting from cell to cell | Excel Discussion (Misc queries) | |||
| copying the function contained within a cell to anouther cell. | Excel Worksheet Functions | |||
| Copying data down to next dirty cell, then copying that data | Excel Programming | |||
Linear Mode
