I get a "Run-time error '91': Object variable or with block variable not set" error. I think it might have something to do with the date format. In the worksheet the format is m/d/yy but I think when it tries to do the find it is using m/d/yyyy which it doesn't find and then gives the error. If this truly is the case, is there a way around the date formatting issue to allow the find to work?
Please Login or Register to view this content.
Try change
Please Login or Register to view this content.
Hi Bob- is the 'Find' in a loop? If you're trying to find successive hits, you use Find once, remember the first address, then loop w FindNext until you hit first address again (wrap-around).
Last edited by leelnich; 06-06-2017 at 12:46 AM.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks