Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
Hi,
I'm trying to use the less than operator to compare dates in a worksheet against the date in a variable. The = sign works ok, but neither the = or <= does not. Here is the code, any help in using mainly the = operator would help greatly. Do While Not IsEmpty(ActiveCell) If ActiveCell.Value = startDates Then startRange = ActiveCell.Address Exit Sub Else ActiveCell.Offset(1, 0).Select End If Loop Thanks CathyZ |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Adding XY days to date in cells | Excel Discussion (Misc queries) | |||
Another Date issue. | Excel Worksheet Functions | |||
Date comparison | Excel Discussion (Misc queries) | |||
Date Math Problem | Excel Worksheet Functions | |||
Need help troubleshooting an array formula XLXP on Win2K | Excel Worksheet Functions |