1 for their Editors Pick of Computer Books for 2004. .
The solution offered by Darren was to use the split function.
Jan 10th, 2012, 08:33 PM #9 Re: VBA Excel Assigning values to array in a single line Here's how I would accomplish what I think you're requesting.
I'd like to see the Split fail.The first parameter, M, is the number of bins (breaks) that you want to have for the histogram. .Jan 10th, 2012, 07:13 PM #6 Re: VBA Excel Assigning values to array in a single line Originally Posted by opus You didn't ask for a way with less memory usage, you asked for a way to fill the array using a single line!This ' returns the value from the second column of the range A1:B8 within the current worksheet.Jan 10th, 2012, 10:21 PM #16 Re: resolved VBA Excel Assigning values to array in a single line Good advice I may try this when I'm done and post the results.So first, select cells C2 to C6 (or any other range on the worksheet that contains 5 consequent cells).Jan 10th, 2012, 09:45 PM #13 Re: resolved VBA Excel Assigning values to array in a single line Originally Posted by Earlien Hmm, I tried declaring super street fighter ii game the array as an integer then removing the "A,B,C" part but it returns type mismatch [email protected] Opus: Actually, your idea of using a variant data type may not be as inefficient as I would have thought.String expression containing substrings and delimiters.If the formula is not entered by pressing ctrlshiftenter, cell C2 will return.This way, the maximum and the minimum values can be derived and used for setting up the bin values and the linear interpolation can be used to get each of the bins.
After assigning the argument values, press ctrlshiftenter.