vba: How do I write a "For Each Statement" nested in a "With Statement"?
To clarify futher: The end user will be entering just one date at a time... He/she want to pull all customer records on the worksheet that are listed in colum 68 for a specific date. Lets say 10/23/2004. so the user types 10/23/2004 in the input box. and maybe 10 different customers will be returned for 10/23/2004. right now, because my for each statement doesnt work (or maybe Im usin the wrong logic) I only get the first customer record on the workshee for 10/23/2004 even though there are 9 more records on that date. Any Ideas -- Mcastee ----------------------------------------------------------------------- Mcasteel's Profile: http://www.excelforum.com/member.php...fo&userid=1569 View this thread: http://www.excelforum.com/showthread.php?threadid=27639 |
All times are GMT +1. The time now is 01:23 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com