Search results for query: *

I forgot to mention the error that I get: Run-time error '1004': Unable to set the XValues property of the Series class thanks, Neil

Thank you for your help. Your suggestion seems to work. However, I'm having a little trouble with the X-axis, and I think it has to do with the fact that the string I'm supplying to ActiveChart.SeriesCollection(1).XValues = is actually a string of strings (one,two,three), and not a string of...

Just wondering whether it is possible to plot an array into a chart. I have 2 arrays of data which I would like to plot against eachother, but I'm not sure (1) whether this is doable in VBA Excel or (can you only plot something referenced in the sheet itself, ie "K1, K2..."?) and (2)...

Thanks once again. Both of your methods work. I prefer the 2nd method only because after the data has been processed, clicking in that cell shows you the formula that was used. The first method works perfectly except that only the calculated value is displayed, and not the formula. Thanks so...

Within VBA, is there a way to select more than one cell not located next to a previously selected cell...just like using the control button within the Excel application? For x = 1 To Ubound(MyArray) For y = 1 To Ubound(MyOtherArray) If MyArray(x) = MyOtherArray(y) Then...

Hi, Thanks for the help. That worked almost perfectly. The syntax is correct, however...whereas before I was able to populate the columns with y = integer, it is not letting me perform the calculations with an integer. The result of the code you helped me with is "AVERAGE(1:1)...

I populate a column with data through a loop. I refer to the column with a variable, y. For .... Cells(x, y).Value = Data(z) x = x + 1 Next I want to use Excel's built-in Average and Stdev functions to calculate stats at the end of the data in each specific column....but I want to use...

The mean values come out okay. It's actually the corrected StDev and CV values that are having this issue. It's rather bizarre as only a few of the StDev's and CV's are presented as -1.#J and others are presented correctly. I've narrowed it down to it happening when the value is .00 (StDev) or...

After using the FormatNumber function, it seems as if some of my numbers are coming out okay, but others are being presented as "-1.#J". All the calculations are put through the same loop and all the number results are presented through the same loop....so it is a bit confusing why...

Hi Jon, Your code works. I just had to add it to another area of the code (as I said before, I'm working on someone else's stuff). Thanks so much for the help. I appreciate it. -Neil

Hi Jon, Thanks for your help. Your code definitely works better than anything else I've tried...but it still doesn't work completely. It allows the script to recognize "_test", but still doesn't match other things like "my_test" or "some_test". Any ideas why it...

Hi John, Thanks for your helpful and timely response. I was wondering if there was a different way of doing this without the use of Regular Expressions. I'm actually working on someone else's code that no longer works here and I'm trying to change as little as possible. Basically, he set a...

I was just wondering whether VBScript allows for the use of wildcards. For example, I'm looking to compare a known string with a list of user inputted strings. If one of the inputted strings contains the known string, I would like to display that string value. It works if the strings match...