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
Can you post a copy of the workbook? It will make analysis so much easier.
Martin
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
Last edited by rachmanchester; 09-28-2014 at 04:14 PM.
Try this edit
Please Login or Register to view this content.
THANK YOU!!!
You are excellent.
:D
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.
_________________
Microsoft MVP 2010 - Excel
Visit: Jerry Beaucaire's Excel Files & Macros
If you've been given good help, use theicon below to give reputation feedback, it is appreciated.
Always put your code between code tags. [CODE] your code here [/CODE]
?None of us is as good as all of us? - Ray Kroc
?Actually, I *am* a rocket scientist.? - JB (little ones count!)
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks