View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.programming
Wild Bill[_2_] Wild Bill[_2_] is offline
external usenet poster
 
Posts: 90
Default Can .FindNext return Nothing??

You're quite right - thank you. Careless of me. Well it would help if
Wild Bill actually tried it in VBA rather than assume that the default
VBA action mimicked the sheet edit Find!

(Actually, in some of my tests I had the arg as c but the disturbed
voices in my head said there was no argument there - for the benefit of
any mental health professionals that read this :-O )

On Fri, 29 Apr 2005 21:34:03 -0700, "Doug Glancy"
wrote:

But if I remove the "After" argument from "Findnext":

Set c = .FindNext()

it just keeps finding B1, which is as the help text describes.