Trying to build a VBA Macro to delete rows based on multiple conditions.

I have an excel table with Columns [A - AD]
I also have 8778 Rows (Which is different each time

Column P has data manufacturer Example: Dell Computer
Column K has data price Example: 210.00

The macro has to delete rows if the following conditions are not met.

Delete row if (Column A = 'Dell Computer' AND Column B <= 250.00)


Sub sbDelete_Rows_Based_On_Multiple_Criteria()
Dim LastRow As Long
Dim iCntr As Long

'Find LastRow Using UsedRange
sht.UsedRange 'Refresh UsedRange
LastRow = sht.UsedRange.Rows(sht.UsedRange.Rows.Count).Row


.... Not sure what to do here? ...


End Sub



Any help would be greatly appreciated. I search around for an answer, but came up short. Each application is so unique.