Change Event and Calculated cells
Howdy;
I am interested in using the worksheet code to look at two
cells, which in turn become the X-axis scale max/min. The
cells are calculated, and based on Cpearson.com, Change
Event does not fire from calculated cells. Ultimatley the
cell changes based on the user selection from a Form
dropdown.
For example, the dropdown contains 7 day, 30 day, 90 day
options and the changing cells find the right begin/end dates.
I have the whole process working based on dyanmic ranges,
but it seems cleaner/easier to graph the whole dataset and
adjust the scale limits.
Regards,
Tim
|