| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Next w/o For If/Then Loop
I have a For/Next Loop setup, but in the middle of it I need an If/Then Statement. My For/Next Loop scans a list of Dates and then transfers them to an Outlook Calender. However, I dont need it to transfer anything from before the day I run the macro. I tried inserting the following code: If olDate < Date Then Next x End If When I use this I get a Next without For error. Is there a way to use Next inside an If/Then conditional if the For resides outside the If/Then? Thank you very much for any and all help. -- littlegreenmen1 ------------------------------------------------------------------------ littlegreenmen1's Profile: http://www.excelforum.com/member.php...o&userid=23978 View this thread: http://www.excelforum.com/showthread...hreadid=377526 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| loop trough e-mail address list to send task lists with outlook | Excel Discussion (Misc queries) | |||
| Loop through email address list to send e-mails | Excel Discussion (Misc queries) | |||
| Password Loop question. | Excel Discussion (Misc queries) | |||
| Printe Autofilter Criterias in a Loop | Excel Discussion (Misc queries) | |||
| Please help with loop | Excel Discussion (Misc queries) | |||
Threaded Mode
