Re: $$Excel-Macros$$ array sort issue

Hi Ted, Instead of "Excel.WorksheetFunction.Len" just use "Len". So your code would look like: iLen = Len(ary(iLoc)) Len function is available as VBA function too, so you don't need to use excel function. This is same as you are doing for conditional statement, IF. Note: The moment you press . (

Re: $$Excel-Macros$$ array sort issue

Then so... Paul - Original Message > From: Ted > To: MS EXCEL AND VBA MACROS > Sent: Mon, November 8, 2010 1:46:07 PM > Subject: $$Excel-Macros$$ array sort issue > > In an attempt to develop my own sort for an array, I seem to have run > into a probl

$$Excel-Macros$$ array sort issue

In an attempt to develop my own sort for an array, I seem to have run into a problem. I don't know what I 'm doing wrong specifically, but as soon as I attempt to invoke the Len Function, the whole thing breaks. subscript out of range error. I think I may be overthinking this, so any guidance is