View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.programming
TGalin TGalin is offline
external usenet poster
 
Posts: 81
Default Delete Specific Contents

Cool! It works great thank you! I appreciate you're help.

"Jacob Skaria" wrote:

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