View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.programming
Steve Wylie Steve Wylie is offline
external usenet poster
 
Posts: 15
Default Searching across all sheets

Ah! Typical - just when I asked for help I find a
solution myself.

If Not rng Is Nothing Then
Application.Goto rng, True
response = MsgBox("Cancel search ? ", vbYesNo)
If response = 6 Then Exit Sub
End If

This seems to do the job. Thanks anyway!

Steve