| Home |
| Search |
| Today's Posts |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Code to copy selective cells from matching rows
I think one of your counters is wrogn. lngLastRow2 = lngLastRow2 + 1 It looks like you are trying to put a space between each row in the detination which would mean you would need this lngLastRow2 = lngLastRow2 + 2 -- joel ------------------------------------------------------------------------ joel's Profile: 229 View this thread: http://www.thecodecage.com/forumz/sh...d.php?t=170347 Microsoft Office Help |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| copy matching value rows to other sheet | Excel Discussion (Misc queries) | |||
| count number of rows with 2 matching text cells | Excel Worksheet Functions | |||
| Matching rows in 2 sheets and copying matching rows from sheet 1 t | Excel Programming | |||
| copy / paste selective rows | Excel Discussion (Misc queries) | |||
| Loop cells - get all rows with matching data - paste into different wb | Excel Programming | |||
![joel[_539_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Threaded Mode
