I have a VB app that uses a VBA script to create a sheet with data and then
another sheet with a chart representing that data in graphical form. The
sheet with the data on it has formulas that are run on a subset of the data.
Currently these formulas are hardcoded with the range to calculate from. But
I need to change it so the user can select a starting and ending point from
the chart (on the other page) that the formulas will use to calculate from.

I am new to Office scripting so any ideas on how to do this (if it's even
possible) would be helpful.

Thanks.