Faster way to autofill dates

[spewer]

I have searching around and haven't an elegant way to create a range of dates faster.
I have two cells that contain dates. I named those two cells as ranges. The user is fill out those two dates. From those two dates, the macro will go look at those two dates and create range of two dates. From that info, another function will do some data manipulation and create a trend chart.
The problem, if I use a for loop, it takes excel a long time to create a column of dates (based on the user entry). Is there a faster way to autofill between two dates?

Please Login or Register  to view this content.

[JieJenn]

Can you attach a sample file? Too lazy to go through your code without knowing what the raw data looks like

[spewer]

Here is a xlsm file with my simple macro

[JieJenn]

This might give you the same result too

Please Login or Register  to view this content.

[spewer]

Yep. That worked and it is fast. Thanks JieJenn!