Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Selecting Range Based on Cell Content then Copy/Paste to New Sheet,Looping
I have a worksheet that consists of 13 columns and multiple varying
rows of data of 4 to 10 rows set up like the example (column M) starting on row 7. What I would like to accomplish is to select the areas containing 2 on the last row last column up to blank row and paste them to a new sheet looping through entire worksheet. I’ve tried using ActiveCell.CurrentRegion.Select but there are blank columns in some areas. I’ve also looked at xlUp and think it may work but I’ve only been able to select cells not rows. Altogether, I’m having trouble selecting the areas as well as looping through sheet with 264 rows of varying row sizes of data. I’ve looked through previous postings and haven’t seen a similar problem. I hope my example is clear enough. Thanks, Paul Blank Row 1 1 1 1 1 1 Blank Row 1 2 2 2 Blank row |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Copy paste without selecting sheet or range | Excel Programming | |||
Copy and paste row based on cell content | Excel Programming | |||
based on Cell/Column content ,cut one sheet's values and paste it in other sheet? | Excel Programming | |||
Finding a named range based on cell value and copy/paste to same sheet? | Excel Programming | |||
Copy/Paste based on cell content. | Excel Programming |