| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Looping through a Range and copying to Another Sheet
Hi there,
I am new to VBA, and I am wondering if its possible to do the following: I have a range of data (dynamic), which shouldn't go any more than 200 rows, and is within columns A:H. What i want to do is loop through the range and anything which has "CCLS" within column H, then copy it to sheet CCLS. Sometimes there might not be "CCLS" within column H, so some sort of error code may need to be added to make the code work. tia Harry |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Copying Range Based On Certain Criteria? Possible looping through the Range | Excel Programming | |||
| Copying a range to another sheet | Excel Discussion (Misc queries) | |||
| Copying Range from 1 sheet to next | Excel Programming | |||
| Copying a particular range of values from one sheet to another in excel | Excel Programming | |||
| Copying a Filtered Range from a Sheet in another Workbook | Excel Programming | |||
Threaded Mode
