View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Dolphinv4 Dolphinv4 is offline
external usenet poster
 
Posts: 27
Default Find empty cell then stop

Hi,

I'd like to have a macro that does this:

1) for cells in column F that is a) not empty & b) greater than 3000000,
search thru column K for the first empty cell. If there is, a message box to
be shown for the cell address. Then the whole macro should stop.

Thanks,
Dolphin