vba: How do I write a "For Each Statement" nested in a "With Statement"?

M

Mcasteel

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

vba: How do I write a "For Each Statement" nested in a "With Statement"? 1
Avoiding nested if statements? 14
Finding multiple occurances of a date within one column: Should be easy? 1
vba: How do I write a "For Each Statement" nested in a "With Statement"? 0
how do I write an IF/other statement to capture certain time data? 1
VBA: For Each... Statement, Expert? 1
Reletive Referencing of Another Cell's Formulas 2
vba: How do I write a "For Each Statement" nested in a "With Statement"? 1

Top