| Home |
| Search |
| Today's Posts |
|
#29
Posted to microsoft.public.excel.programming
|
|||
|
|||
Delete matching cells
On Sun, 15 Jan 2012 16:47:41 -0800, "Jim Cone" wrote:
Ron, Actually, I misspoke, the Dictionary is zero based, but the recommendation stands. Also, the two lines near the end should read... rColA.ClearContents Set rColA = rColA.Resize(dColA.Count, 1) '--- Jim Cone That is if you remove the +1. As I wrote, when that was written I had assumed a column label. If the column label is unique, and not found in Column B, then it can be included as I did in a subsequent response, following your suggestion, to the OP. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Delete all cells in range matching certain values | Excel Programming | |||
| Help with Matching Text Fields - Then Moving the Matching Cells Side by Side | Excel Discussion (Misc queries) | |||
| DELETE ROW 3 MATCHING CRITERIA | Excel Programming | |||
| delete all matching rows | Excel Discussion (Misc queries) | |||
| Perform Lookup and delete non matching rows? | Excel Programming | |||
![Ron Rosenfeld[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Threaded Mode
