Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Delete Row Macro - if cell $5000
Hi,
How do I delete a rows in Column F if a cell reflects a value of more than $5,000. Thanks |
#2
|
|||
|
|||
Delete Row Macro - if cell $5000
You can do it with a VBA macro:
Sub AAA() Dim LastRow As Long Dim RowNdx As Long LastRow = Cells(Rows.Count, "F").End(xlUp).Row For RowNdx = LastRow To 1 Step -1 If Cells(RowNdx, "F").Value 5000 Then Rows(RowNdx).Delete End If Next RowNdx End Sub -- Cordially, Chip Pearson Microsoft MVP - Excel Pearson Software Consulting, LLC www.cpearson.com "Danny" wrote in message ... Hi, How do I delete a rows in Column F if a cell reflects a value of more than $5,000. Thanks |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Keyboard Macro Just Copies Content of Previous Cell | Excel Discussion (Misc queries) | |||
move to another cell within a subtotal report within a macro | Excel Worksheet Functions | |||
copying cell names | Excel Discussion (Misc queries) | |||
Possible Lookup Table | Excel Worksheet Functions | |||
Copy cell format to cell on another worksht and update automatical | Excel Worksheet Functions |