VBA Month And Day With A Do While Loop


Sub EnterDates()      myDate = "2/3/2008"      Row = 4      Col = 2      Do While Col <= 51           Cells(Row, Col).Value = Month(myDate) & Chr(10) & "-" & Chr(10) & Day(myDate)           myDate = DateAdd("d", 1, myDate)           Col = Col + 1      Loop End Sub



Pulled from: VBA Month And Day With A Do While Loop

Post a comment for www.mgwalk.com
 
Send your comment to www.mgwalk.com
 
Name:
Email:
Web Site:
Rating:
star blank star blank star blank star blank star blank (move mouse over star to select rating)
Comment:
Anti-spam word: (Required) *