in reply to Simple Question - Simple Answer, I hope.

Instead of writing code to do your search, you could make Excel do the work for you, by using the Find method of the Range object.

Details at MSDN.

     "As you get older three things happen. The first is your memory goes, and I can't remember the other two... " - Sir Norman Wisdom

  • Comment on Re: Simple Question - Simple Answer, I hope.

In Section Seekers of Perl Wisdom