LinkBack URL
About LinkBacks
Schwizer 
I have the following code
I then get the first value of the variant using
xrange = ActiveChart.SeriesCollection(1).XValues
But how do I get the last date?startdate = xrange (1)
Schwizer
Getting index of variant
I have the following code
I then get the first value of the variant usingxrange = ActiveChart.SeriesCollection(1).XValues
But how do I get the last date?startdate = xrange (1)
Schwizer
Maybe ...
Dim xRange As Variant Dim dateBeg As Date Dim dateEnd As Date xRange = ActiveChart.SeriesCollection(1).XValues dateBeg = xRange(1) dateEnd = xRange(UBound(xRange))
Entia non sunt multiplicanda sine necessitate
Appears to work.
Thank you.
You're welcome.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks