Folks,

I have a macro which a programmer wrote but I have to make some
changes...

essentially there is time data in column A and temperature data in
column B. The macro opens a box and queries start data and end data
and then determines min and max temp and such.

Now I need the macro to also creat a chart for that range. I have the
start and end date isolated in fields but dont know how the macro could
select the data in between for the chart...

I am not a programmer and havent figured out the R1C1 adress system ...
I havent figured out if it can address through variables, which may
solve the problem

any help appreciated!

Matt

anybody? Is it even possible?

I have the cells for the applicable date range copied into a new column
which only containes data that needs to be charted but the amount of
data, start and end is different each time so the macro needs/vba
needs to pick the first and last cell with data and then build a chart
from it.

Is that possible?

Thanks,

Matt

You may want to use a named dynamic range instead.

Check out

http://peltiertech.com/Excel/Charts/Dynamics.html

In article .com,
"Matt" wrote:

anybody? Is it even possible?

I have the cells for the applicable date range copied into a new column
which only containes data that needs to be charted but the amount of
data, start and end is different each time so the macro needs/vba
needs to pick the first and last cell with data and then build a chart
from it.

Is that possible?

Thanks,

Matt

thanks, they are interesting .. but they seem to only work if your
first cell is fixed and only tha last varies .. I have first and last
varying :(