| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Format(Now) will not work for Feb.+
I'm using the logic below to update items for the current date. This works fine for January, but won't work for Feb. and on for some reason...  Any help will be greatly appreciated! Today = Format(Now, "M/DD/YYYY") col_Numb = 1 'Find the current date for update Do col_Numb = col_Numb + 1 Loop Until Sheet1.Cells(5, col_Numb).Value = Today Or col_Numb = 25 TIA -- cultgag ------------------------------------------------------------------------ cultgag's Profile: http://www.excelforum.com/member.php...o&userid=22677 View this thread: http://www.excelforum.com/showthread...hreadid=508917 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Format(Now) will not work for Feb.+
supposing your sheet holds dateserials, why make Today a string? assign it like Today = Date (today must be dimmed as a variant or a date/time. even simpler to dmnp your today variable and do: Loop Until col_Numb = 25 or Sheet1.Cells(5, col_Numb).Value = Date -- keepITcool | www.XLsupport.com | keepITcool chello nl | amsterdam cultgag wrote : I'm using the logic below to update items for the current date. This works fine for January, but won't work for Feb. and on for some reason... Any help will be greatly appreciated! Today = Format(Now, "M/DD/YYYY") col_Numb = 1 'Find the current date for update Do col_Numb = col_Numb + 1 Loop Until Sheet1.Cells(5, col_Numb).Value = Today Or col_Numb = 25 TIA |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Format(Now) will not work for Feb.+
I dumped Today like you said and it worked like a charm! THANKS! : -- cultga ----------------------------------------------------------------------- cultgag's Profile: http://www.excelforum.com/member.php...fo&userid=2267 View this thread: http://www.excelforum.com/showthread.php?threadid=50891 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| format cell does not work | Excel Discussion (Misc queries) | |||
| Format .txt file contents to numeric format will not work - help! | Excel Discussion (Misc queries) | |||
| currency format doesn't work first try | Excel Discussion (Misc queries) | |||
| Format() doesn't work from a Form | Excel Programming | |||
| Keep format after paste from other worksheets - conditional format or EnableControl solution doesn't work | Excel Programming | |||
Linear Mode
