Using range and cell variables in the series function

[rachmanchester]

Hello,

I am trying to automate a report where specific data is pulled out, saved as a range variable and then used to update a number of existing graphs.

I'm having trouble referencing the variables correctly in the code - please could someone help me with this?

Please Login or Register  to view this content.

It's the final line before 'End Sub' that is causing the problems!!

Any help would be much appreciated.

Thanks,
Rachael

[mrice]

Can you post a copy of the workbook? It will make analysis so much easier.

[rachmanchester]

Automatic report building Example.xlsm

This is the simple example workbook I've been working on... The real one is very similar, there's just a lot more data and more graphs to update.

Normally, you press "create a report" then the userform feeds the year and month that you choose into the code. It retrieves the ranges fine and they work in simple functions such as 'average' but I'm doing something wrong for the series function it seems!

Thanks for you help,
Rachael

[mrice]

Try this edit

Please Login or Register  to view this content.

[rachmanchester]

THANK YOU!!!

You are excellent.

:D

[JBeaucaire]

As it appears you've reached a conclusion, I've marked this thread SOLVED for you.
FYI, this is done through the Thread Tools located above the first post in this thread. Thanks.