Reply to thread

Message: [QUOTE="ker_01, post: 6336205"] I looked a everything I could find different between the simplified code you provide (which works for me in a new workbook) and the workbook that is giving me trouble; I added them all to the simplified workbook just in case any of them might have been a problem (although I didn't predict that any of them would); * I removed ".value" from my old assignment of "Sheet1.range("B1:B10000").value" * I dimmed the variant array as public instead of within the sub to more closely match my real code * I adding option base 1 to the module to match my real code * changed the range reference in the simplified workbook to be pseudo-dynamic: Sheet1.range("B1:B" & cstr(10000)) to resemble the real code everything still works fine in the new workbook- I can't get it to throw as a 2D array like my main workbook. As far as I can tell, other than the actual data in the real worksheet, nothing else is different... Now I'm really confused. :( Thanks, Keith [/QUOTE]