View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
maia maia is offline
external usenet poster
 
Posts: 2
Default Deleting cells using VB (macro)

Hi.
I have a macro that deletes cells from A1 till A10.
What I'd like the macro to do for me is if the macro finds a specific cell
name (string), then it doesn't delete the cells having that string. If it
doesn't, then delete every cell not cointaining that scheme.

Example: If I have the letter "C" in cell A2 and A7, I'd like the macro to
delete every other cell, ranging from A1 till A10 (excluding A2 and A7 that
has the "C" string).

Best regards