| Home |
| Search |
| Today's Posts |
|
|
|
#1
|
|||
|
|||
Delete a whole row using a macro
I am trying to set a macro up in Excel so that it will check a value in
column A and if the value equals 'abc' (or whatever other value), I want to delete the row all together. I haven't used VB in a long time, and I don't know how to get started... Any help will be greatly appreciated. Thank you |
|
#2
|
|||
|
|||
|
cLastRow = Cells(Rows.Count,"A").End(xlUp).Row For i = cLastRow to 1 Step -1 If Cells(i,"A").Value =, "abc" Then Cells(i,"A").EntireRow.Delete End If Next i -- HTH RP (remove nothere from the email address if mailing direct) "LaurenceL" wrote in message ... I am trying to set a macro up in Excel so that it will check a value in column A and if the value equals 'abc' (or whatever other value), I want to delete the row all together. I haven't used VB in a long time, and I don't know how to get started... Any help will be greatly appreciated. Thank you |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Cannot delete a macro | Excel Discussion (Misc queries) | |||
| Is there a way to insert a formula, password or macro in an excel spreadsheet that will automatically delete the spreadsheet? | Excel Discussion (Misc queries) | |||
| delete row contains specific word in an macro | Excel Discussion (Misc queries) | |||
| How to delete a macro that has been assigned to run when workshee. | Excel Worksheet Functions | |||
| Macro to delete a macro | Excel Worksheet Functions | |||
Hybrid Mode
