LinkBack URL
About LinkBacks
hi, i have some code which searches through a document for a string.. but currently it stops after 7th page!
why is this?
thanks
Please Login or Register to view this content.
hi, i have some code which searches through a document for a string.. but currently it stops after 7th page!
why is this?
thanks
Please Login or Register to view this content.
Last edited by Jollyfrog; 11-02-2010 at 12:24 PM.
what do you mean by stops?
Without seeing the actual data your code in trying to process it's impossible to say.
Have you stepped through your code to make sure all sheets are being processed and that the cell contents you are checking actually match.
hello,
yes i have stepped through the code and it returns values correctly for the first few hundred iterations..
when i run the code as a whole, the prgram seems to terminate, without errors or crashing, the giveaway is the ws.select line which basically highlights the last page where a match was found, this always seems to happen on page 7 out of about 30!
Thanks
Jonathan
ok..
after worksheet i added
ws.select
now it works,
i'm guessing because it would lose foucus of the correct sheet after a match was found
You find the problem before I could reply.
You need to qualify fully the cells reference.
So maybe your code should look more like
Please Login or Register to view this content.
I think you'd better use advancedfilter
ok, thanks
i'll add that to the memory bank
Jonathan
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks