View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Roger Roger is offline
external usenet poster
 
Posts: 226
Default If Then macro needed

I have a situation where I need to insert a line of code into a macro I have,
but I need some help.

I need to have the macro present a message to the user if any number is
present in a particular cell.

So basically this: If cell a7 contains "any number" then message box "this
cell contains QTY"...

thanks in advance for the assistance.