| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Copy rows macro
Hi, I need a macro that will copy rows as follows.
I have values in Cells A1:C1, A101:C101, A201:C201 etc..... All of the cells between 2-100, 102-200 ... are blank. I need a macro that will copy cell A1:C1 and paste special as values below in the range A2:C100 and the same for all subsequent rows below so in the end all the blank spaces will be full. Thanks |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Macro to copy rows | Excel Discussion (Misc queries) | |||
| Macro to Copy Var. Ranges to Var. Rows | Excel Discussion (Misc queries) | |||
| Copy Autofiltered rows to another workbook using macro | Excel Discussion (Misc queries) | |||
| Macro to copy cells to rows below | Excel Discussion (Misc queries) | |||
| Create a Macro that will copy the rows that have a value < 0 | Excel Discussion (Misc queries) | |||
![Chris_t_2k5[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Threaded Mode
