P0lar
Member
Hi,
I have a formula which creates a string including a superscript 0,1,2 or 3 - represented by chr(185), 186, 179 and 178:
¹0800-1500¹
I would like to pass this into an array in VB but can only fill the array with the #N/A "error 2042" for some reason, I suspect this may be due to the data type which is set as variant (I tried string data type as well)
I have a formula which creates a string including a superscript 0,1,2 or 3 - represented by chr(185), 186, 179 and 178:
¹0800-1500¹
I would like to pass this into an array in VB but can only fill the array with the #N/A "error 2042" for some reason, I suspect this may be due to the data type which is set as variant (I tried string data type as well)
Code:
Dim OP(21) As Variant
j = 9 to 27
OP(j - 9) = Sheets("Filter").Range("O20") 'the cell with the above string in it
next j