Delete Specific Contents
Dear Galin
Please find the below code. Incase you are not familiar with macros follow
the below instructions. Launch VBE using Alt+F11. On the left treeview, right
click 'This Workbook' -- Insert-- Module . Paste the code. Goto workbook
and Run Macro1 from Tools--Macro
If this post helps click Yes
---------------
Jacob Skaria
Sub Macro1()
intRow = ActiveSheet.Range("A65536").End(xlUp).Row
For intTemp = 1 To intRow
If Range("A" & intTemp) = "User" Or Range("A" & intTemp) = "Theodore Galin"
Then
Range("A" & intTemp) = ""
End If
Next
End Sub
|