Find and Find Next, workbook - microsoft.public.excel.programming

Message from discussion Find and Find Next, workbook

DMcRitchie

More options Mar 13 1999, 3:00 am

Newsgroups: microsoft.public.excel.programming

From: dmcritc...@aol.com (DMcRitchie)

Date: 1999/03/13

Subject: Re: Find and Find Next, workbook

  Reply to author
  |
  Forward
  | Print
  | View thread
  | Show original
  | Report this message
  | Find messages by this author
  

Hi Brian, (posted with email copy)
Take a look at these archived postings which search each sheet.
http://www.dejanews.com/getdoc.xp?AN=434611017
http://www.dejanews.com/getdoc.xp?AN=331671730

I think you will find what you want in either of the above, specifically
looping through worksheets. I prefer to list pages to look at rather than
simply having code reposted over and over again. If those postings do not help
try looking at other postings in DejaNews archives. If that doesn't help you
will at least be able to ask a very specific question that covers why nothing
you found works for your situation.

DejaNews Power Search:
http://www.dejanews.com/home_ps.shtml

Search Keywords: sheets & for & next & sub
Subject: find
Forum: *excel*
Results Format: threaded
Results per page: 100

HTH, (I also have a page on searching newsgroups)
David McRitchie
My Excel Pages: http://members.aol.com/dmcritchie/excel/excel.htm

>From: brian4...@aol.com (Brian4777)
>I've been trying to write a procedure for 1 month now and i just can't get it.
>The procedure is for a find next that encompasses the entire work book. I can
>get everything to work for one sheet, but when i try to get it to go to next
>sheet everything goes to pot. If anyone has this code or can help me I would
>really apprecitate it.
> Brian

Reply to author Forward