returns a two dimensional array when there is more than one cell of data. With one cell of data it returns a string or integer variable.
I need to turn the single item into an array to be consistent with reading the value from an array.
Array(aC,"") = aC
Array("",aC) = aC
Array(1,0) = aC
Array(0,1) = aC
I dont think that I can do a redim because I did not declare it as ac() with parenthis.
Assistance needed please.
aC = xlsh.UsedRange ' This gets the entire sheet into the array.
' If there is only one cell used in the sheet UFT returns a variable and not an array. We need to force an array with 1 element.
If Not isarray(aB) Then
strAC = aC
aC(1,1) = strAC