View Single Post
  #7   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?

One time, but a count of the found errors would be better, so I
know have an idea of how many problems I fixed when I fixed one
cell.


This may get you started but not sure what you mean about fixing one cell.

Sheet event code to count error cells after calculation takes place.

Private Sub Worksheet_Calculate()
Dim rng As Range
On Error GoTo endit
Application.EnableEvents = False
Set rng = Me.Range("A1:M100").SpecialCells(xlCellTypeFormula s, 16)
MsgBox rng.Count & " Errors found!!"
endit:
Application.EnableEvents = True
End Sub


Gord