Why can I not make VBA Excel write me the date I put in the code, rather it shows always 00/01/1900 pls? See I wrote a short code that fills in the woorkbook (sheet), the date (any date) as a responce to a week number. The problem is that the code is only returning one single meaningless value of (00/01/1900), and that is after me formatting the cell to a date cell. before that it has asigned another funny date with (time) this time. 1 day ago - 3 days left to answer. Additional Details this is just a part of the procedure discribed in my original question. This is the part that's not working. pls try it to see if it gives you the same result described in my Q: above? Many many thanks to your reply. Sub proDate() Dim varDate As Date Dim varWkNr As Integer varWkNr = 1 If varWkNr = 1 Then varDate = 13 / 10 / 2010 Range("A1").Value = varDate End If End Sub
Free Guide: Managing storage for virtual environments
Complete a brief survey to get a complimentary 70-page whitepaper featuring the best methods and solutions for your virtual environment, as well as hypervisor-specific management advice from TechTarget experts. Don’t miss out on this exclusive content!