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
|