Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Shaun E on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
plot an array
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)...- ntolani
- Thread
- Replies: 7
- Forum: VBA Visual Basic for Applications (Microsoft)
-
selecting multiple noncontiguous cells
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...- ntolani
- Thread
- Replies: 1
- Forum: VBA Visual Basic for Applications (Microsoft)
-
using variables with built-in functions
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...- ntolani
- Thread
- Replies: 4
- Forum: VBA Visual Basic for Applications (Microsoft)
-
FormatNumber
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... -
wildcard?
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...
