| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Deleting rows within a named range
I have the following code
For Each r In myRange If LCase(oWS.Name) = "status" Then Debug.Print r.Address, myRange.Address If r.Text < fNameNew Then r.EntireRow.Delete End If End If Next r Let's say myRange.address = B5:B23 If row 6 is deleted, the next r.address that's reviewed is B7, not a repeat of B6. What do I need to do to fix this? Thanks, Barb Reinhardt |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Selecting and deleting named range based on cell value | Excel Programming | |||
| how do i maintain named range addressing after deleting row? | Excel Programming | |||
| How to add rows(cells) to a named range | Excel Programming | |||
| Deleting named ranges by looping through range collection | Excel Programming | |||
| Deleting a named range in VBA | Excel Programming | |||
Threaded Mode
