Type Mismatch Errors Using Arrays

[Genus Max]

Hi, I'm trying to copy a range to an array, but I keep getting type mismatch errors extracting values from the array to a string.

I get errors on line 18 MsgBox Arr

& line 27 strCityOnly = Left(Arr, InStr(Arr, " ") - 1)



I've enclosed the spreadsheet,

Thanks.,

Please Login or Register  to view this content.

[rorya]

Arr is the entire array. You have to process each element in turn using Arr(R, 1) in your loop rather than just Arr.

[Genus Max]

Thanks!!!!!!!!!!!!!!!!!!!!!!!!!

[Genus Max]

Hey, i'm having problems transposing values from the array. Atm it just copies the first cell several times instead of the entire range ...

Spreadsheet enclosed just in case ..

Thanks

Please Login or Register  to view this content.

[rorya]

If you want to transpose it, your output range should be multiple columns, not multiple rows:

Please Login or Register  to view this content.