Stumped with offsetting destination with AutoFill

[graym463]

Hi there, thanks for looking.

The code below takes two dates, and works out the dates between them & pasted them in the destination Column A.

My dates are variable. I have my code below correctly pasting the ranges into column A ( working in another sub routine ). I need to use this again with a different destination. When I offset the destination to column L I have an error occur - I am stumped on how to do this. I have reverted this code to its format in which it was working.

your help is much appreciated

Please Login or Register  to view this content.

[alansidman]

Try this amended code.

Please Login or Register  to view this content.

[graym463]

That works perfectly. Thanks alansidman