nikki333
04-21-2018, 10:40 AM
Hi Folks
Trying to trim values in an array, however, I always run into a Runtime Error 13 (Types don't match)
For example, I save a worksheet range in an array like so:
Dim myArr as Variant : myArr = ws.Range("A1:A100")
Then trying to trim:
Dim i as variant
For each i in myArr
Trim(myArr(1,i)
Next i
By the way I'm using Option Base 1.
Strangely, If I try to use Trim on a worksheet, I doesnt raise an error, but neither does it trim
Any ideas?
Trying to trim values in an array, however, I always run into a Runtime Error 13 (Types don't match)
For example, I save a worksheet range in an array like so:
Dim myArr as Variant : myArr = ws.Range("A1:A100")
Then trying to trim:
Dim i as variant
For each i in myArr
Trim(myArr(1,i)
Next i
By the way I'm using Option Base 1.
Strangely, If I try to use Trim on a worksheet, I doesnt raise an error, but neither does it trim
Any ideas?