| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Clearing a date vaiable
Hi all,
Hopefully a silly but fast question. Sub myCode() Dim myDate As Date myDate = "" 'Syntax meant for a string... While Not While Not (IsDate(myDate)) 'Misc code here Wend End Sub In the line, myDate = "", what would be the right way to empty this date variable? I tried myDate = Nothing and that did not work either. -- Thanks, Patrick |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| HOW TO CARRY A VAIABLE RESULTS FROM EXCEL SHEET PROCEDURE TO A MODULE | Excel Discussion (Misc queries) | |||
| Clearing data past its sell by date! | Excel Discussion (Misc queries) | |||
| vaiable colours for selection in chart | Charts and Charting in Excel | |||
| Assign vaiable to a cell - gold | Excel Worksheet Functions | |||
| Clearing a date vaiable | Excel Programming | |||
Linear Mode
