Creating a range for a chart based on cell date values

Hi all,

I have a question which I hope you can answer.

In cell A1 I have a date, lets say it is April 2015
In cell A2, I have a date, lets say it is April 2016
In cell A3, I have a figure, lets say it is 50

I would like a piece of VBA that takes the dates in A1 and A2 and creates a range (somewhere beneath the data, exact position doesnt matter) which would be in this example 13 months, and against each we would state a figure of 50 so that we can graph it.

Thanks in advance for your help
Lucy

Hello everyone, is anyone able to help with this question ??

Thanks and sorry to bump

Luce

Sorry to bump again, can anyone help ??


thanks

Luce