Want to add to Excel Macro, unsure how to do what I want

Closed
kapperson
Posts
1
Registration date
Wednesday December 10, 2014
Status
Member
Last seen
December 31, 2014
- Dec 31, 2014 at 09:38 AM
Hello, I have the following Excel Macro that counts the amount of times a specific campaign value is present in a column. I would like to add on to the end of it so that it finds 24 names within the file. I wondered if there was a way to have the macro find a value in the "First" column and a value in the "Last" column (as to avoid deleting duplicates of the first or last name) and delete the entire row that it finds those names in. Any help, advice, etc. would be greatly appreciated!

Sub COUNT()
'
' COUNT Macro
'

'
Range("AE1").Select
ActiveCell.FormulaR1C1 = "=COUNTIF(C[-11],""cash"")"
Range("AE2").Select
ActiveCell.FormulaR1C1 = "=COUNTIF(C[-11],""fhapo"")"
Range("AE3").Select
ActiveCell.FormulaR1C1 = "=COUNTIF(C[-11],""fhapr"")"
Range("AE4").Select
ActiveCell.FormulaR1C1 = "=COUNTIF(C[-11],""harpfn"")"
Range("AE5").Select
ActiveCell.FormulaR1C1 = "=COUNTIF(C[-11],""jumbo"")"
Range("AE6").Select
ActiveCell.FormulaR1C1 = "=COUNTIF(C[-11],""va"")"
Range("AE7").Select
ActiveCell.FormulaR1C1 = "=COUNTIF(C[-11],""vac"")"
Range("AE8").Select
ActiveCell.FormulaR1C1 = "=COUNTIF(C[-11],""valv"")"
Range("AE9").Select
ActiveCell.FormulaR1C1 = "=COUNTIF(C[-11],""vapros"")"
Range("AE10").Select
ActiveCell.FormulaR1C1 = "=COUNTIF(C[-11],""vaprosc"")"
Range("AE11").Select
ActiveCell.FormulaR1C1 = "=COUNTIF(C[-11],""proslv"")"
Range("AE12").Select
ActiveCell.FormulaR1C1 = "=COUNTIF(C[-11],""prosnt"")"
Range("AE13").Select
End Sub