| Home |
| Search |
| Today's Posts |
|
#8
Posted to microsoft.public.excel.misc
|
|||
|
|||
Deleting several rows with given criteria
It's working, Thanks!
"Jacob Skaria" wrote: You can try out the below macro which will look at ColumnA and delete all entries which satisfy the criteria. If you are new to macros.. --Set the Security level to low/medium in (Tools|Macro|Security). --From workbook launch VBE using short-key Alt+F11. --From menu 'Insert' a module and paste the below code. --Get back to Workbook. --Run macro from Tools|Macro|Run <selected macro() Sub DeleteRows() Dim lngRow As Long For lngRow = Cells(Rows.Count, 1).End(xlUp).Row To 1 Step -1 If Range("A" & lngRow) Like "*0100*" Then Rows(lngRow).Delete Next End Sub If this post helps click Yes --------------- Jacob Skaria "Rechie" wrote: I have 1 thousand lines/rows in a sheet. I want to delete rows that contains "0100" text or maybe number. Thanks. Rechie |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Deleting rows by specified criteria for duplicates | Excel Discussion (Misc queries) | |||
| Deleting Rows w/ Specific Criteria | Excel Discussion (Misc queries) | |||
| Help!! I have problem deleting 2500 rows of filtered rows!!!! | Excel Discussion (Misc queries) | |||
| Deleting/IDing Rows that Don't Meet Criteria | Excel Worksheet Functions | |||
| Deleting/IDing Rows that Don't Meet Criteria | Excel Worksheet Functions | |||
Threaded Mode
