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 |
All times are GMT +1. The time now is 11:14 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com