#1
|
|||
|
|||
Setting chart boundaries using cell references.
Hi.
I've been trying to apply http://peltiertech.com/link-excel-ch...lues-in-cells/ to my spreadsheet. But it's not working and I can't puzzle out what the problem is. Long story short I want the chart to update the X-min/Max and Y-min/max if the user changes the values in cells B7/B8/B9. What am I doing wrong? /Møller |
#2
|
||||
|
||||
The code needed to be in the sheet concerned's code-module and there needed to be a few tweaks to the code.
|
#3
|
|||
|
|||
Thanks a bunch mate.
What is the difference between the having the cells in () and []? Also, why should the code be under the sheet and not in the module? These probably really basic questions but I haven't got the foggiest what I'm doing... /Møller |
#4
|
||||
|
||||
Square brackets is short for Evaluate.
It's an event handler so needs to know which sheet the event occurs on. |
#5
|
|||
|
|||
Excellent. Problem solved.
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Inserting Cross References into Cell | mikemike616 | Word VBA | 4 | 08-19-2015 08:43 AM |
Cell references don't change on sort | gebobs | Excel | 3 | 07-23-2015 05:14 AM |
Propagating a formula which references a named cell | Splint | Excel | 4 | 06-15-2015 04:55 AM |
How do I change Excel Chart Object link references from UNC to drive letter? | SusieBennett | Word | 9 | 06-16-2014 05:58 PM |
Macro to change cell references | SaneMan | Excel Programming | 6 | 10-01-2013 02:49 PM |