Store variable value for Chart

  • Thread starter Thread starter Al Jager
  • Start date Start date
A

Al Jager

The value of a cell changes randomly during the day as a
result of a web query i.e. at 10:00 AM the value is 2.3 at
10:15 AM the value is 2.54 etc. How can I store the
individual values so that I can create a chart that
depicts these changes graphically.
Many thanks

Al
 
You need to have a variable to store the target row number and incremen
it with each cycle of the macro (don't forget to initialise it at th
beginning of the macro with rw=0 or whatever).

Something like :-
'--------------------------------------------------------------------
rw = rw + 1
Worksheets("DataStore").Cells(rw, 1).Value = MyTime
Worksheets("DataStore").Cells(rw, 2).Value = MyValue
'----------------------------------------------------------------------
 
Back
Top