Can anybody help me, how can I create an array of some dates in vba?? | Sololearn: Learn to code for FREE!
New course! Every coder should learn Generative AI!
Try a free lesson
0

Can anybody help me, how can I create an array of some dates in vba??

Like list of dates in python

2nd Jun 2019, 5:59 AM
Velivela Sai Chinna Madhu Babu
Velivela Sai Chinna Madhu Babu - avatar
2 Answers
+ 1
Public Class explainArray() Dim arrayDates As Variant Dim MyDate As String arrayDates = Array(CDate("1/1/2000"), CDate("2/2/2000"), CDate("2/3/2004")) MyDay = MyWeek(0) ' "1/1/2000" MyDay = MyWeek(2) ' "2/3/2004"
17th May 2020, 5:41 PM
Michael Herrmann
Michael Herrmann - avatar
0
Thank you.......
20th May 2020, 5:43 PM
Velivela Sai Chinna Madhu Babu
Velivela Sai Chinna Madhu Babu - avatar