Recent content by Ravalia

Can it not be done simply using Conditional Formatting?

Skip, When I try with small arrays (say UBound = 5), there are no problems - the series reads in the array and is plotted appropriately. When I try with something like UBound = 100, I get problems. I believe the problem is that the array is implicitly converted into a formula...

This is a sample: Public Sub graphIt() dim vDates as Variant dim vValues as Variant 'This Works set vDates = Range("myDateRange") Set vValues = Range("myValues") 'But this does not (the xx functions are defined in a library to return arrays of dates/doubles) vDates =...

Hi I'm trying to add series' to line-graphs "on-the-fly" using data retreived from Excel/VBA calls to an XLL. There are no problems if I have a named range containing an array of the values I would like to plot and using VBA to add a NewSeries to the graph and set the .Values property of the...

Mj, Unfortunately, that's a "custom feature" of using ActiveX commandbuttons. I'm assuming that you have some hidden columns (or rows), protection and/or filters applied to the worksheet. In the past I have noticed the same kind of problems whenever I combine ActiveX controls with some of the...

I've just been playing around with a few different ideas: Try out this sample code (should allow the user to return empty & non-empty typed arrays and parse through them without having to check for bounds or provide separate & more costly IsEmptyArray() type functions) Option Explicit Public...

There is a slight problem with the solution above: IF Option Base is 0 OR 0 by default (eg Dim someArr(x) As someType) Then if the array only contains 1 element, LBound(someArr) = UBound(someArr) = 0 BUT the array is not actually empty!

Might be a little late, but I've only just joined this forum: How about the following: worksheets(1).cells(1,1).resize(10000,10).value2 = myArray