View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Matt Matt is offline
external usenet poster
 
Posts: 516
Default Delete and Shift Cells up

Hi all,
I'm trying to create a macro that will start at the very first cell, I guess
A1, and work it's way down, and will check the value of the cell. If the
value of the cell is not equal to the word "Sales" then delete that row. but
if it finds the word sales then stop the process.
Also can I have this macro be able to autorun on the save of the doc? For
instance if I save an email attchment that is an excel file will it run when
I save the attachment without opening the file and then saving it? So to be a
little more clear if I right-click on the excel attached file in the email
and click save, can i have this macro run?