Thank you very much the macro works great. I have one last thing. I need to macro to perform the same task for multiple date ranges within the column until all of the dates are done (e.g. in my orginial file i have up to 50 times the same date under different stocks. I sort the data for stocks and then date, so that the dates are in order for each indiviual stock, then I would run your macro to fill in the missing dates. So the macro needs to do the task over again until all date gaps are filled). Would that be possible? That would be the biggest time saver for me.

Thanks

Kaygu