View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.newusers
Gord Dibben[_2_] Gord Dibben[_2_] is offline
external usenet poster
 
Posts: 621
Default How do I get a popup window on a VLOOKUP lookup failure?

You want a message box pop up if there is any error in any cell out of the
1000's of cells?

What if there are 1,329 errors?

Do you want a message pop up for each one or.........???


Gord Dibben MS Excel MVP

On Wed, 29 Jun 2011 08:34:30 -0400, Mark F wrote:

Doesn't do what I want: I want ANY error to show up in some fixed
location.

There will be 1000s of cells.