| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Paste in alternate rows
I have a source sheet which has the data set in consecutive rows in each of
four sheets. The data has to be copied and pasted in selected workbooks but in every other row. My current procedure works well but is very slow. Is there a more efficient way to accomplish this? The below represents this portion of the operation. Do Workbooks(wbk1).Activate Activecell.Offset(1,0).activate Activecell.Copy Workbooks(wbk2).Activate Activecell.Offset(2,).Activate Activecell.PasteSpecial Loop until (certain conditions are encountered) -- Thanks, Jim |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Formula from consecutive rows to alternate rows? | Excel Discussion (Misc queries) | |||
| Color alternate rows when after hiding selected rows | Excel Worksheet Functions | |||
| sum alternate rows | Excel Worksheet Functions | |||
| macro to paste data in alternate cells-pawan | Excel Programming | |||
| Add alternate rows | Excel Worksheet Functions | |||
Threaded Mode
