| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
How do I get this to look at a date and loop down all the info
Pasty,
You can create as many conditions as you like: If myCell.Value < "" And _ myCell.Value <= Now + 30 And _ myCell.Value = Now And _ myCell(1, 2).Value < "Notified" Then HTH, Bernie MS Excel MVP "Pasty" wrote in message ... Hi there, Its because the due date on some of the cells is less than the the date so it is seeing it as an error. So I need to figure out how to get it to say if the due date has passed then ignore and go through the rest and this is where I am struggling. Regards Matt "Bernie Deitrick" wrote: Sorry. With the address in quotes, since it needs to be a string... .Recipients.Add ") HTH, Bernie MS Excel MVP |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| loop through code and refernce text file for info | Excel Discussion (Misc queries) | |||
| How do I use the IF function with info that contains a date? | Excel Worksheet Functions | |||
| Recovering File Info Specifically Save Date or Print Date | Excel Discussion (Misc queries) | |||
| Calendar and info for that date | Excel Discussion (Misc queries) | |||
| Date selection loop | Excel Programming | |||
Hybrid Mode
