How to list all dates between two dates

[Belleke]

Hi everybody,
I have a userform with a textbox Start Date,End Date & # of days.
I looking for the code that gives me the result as shown in the table when I press the
button.

 

[vletm]

Belleke
Without Your sample file,
Your would get an idea from next to samples:

Sub Do_It()
'   get Your start_date, end_date, days as needed
    For d = start_date To end_date
        Cells(d - start_date + 2, 2) = d
    Next d
' OR
    For d = 0 To days
        Cells(2 + d, 2) = start_date + d
    Next d
End Sub

 

[Belleke]

Hi Vletm,
Thanks for helping me.
See example.

 

[vletm]

Belleke
You didn't test my samples.. hmm?
Your file has 'something' which won't work with my Excel,
but here one sample version as You've written.
Ps. You would add line On Error Resume Next in then beginning of that Sub.

 

[Belleke]

Vletm,
Thanks, this is just fine.
Problem solved.
Have a nice sunday.

 

[Belleke]

Hi,
I was to fast with my answer, a new entry should add at the bottom instead of overwrite.

Never mind, I found the solution with find.

 

[vletm]

Belleke

Never mind