[ad_1]
I am trying to save the ticker symbol I derived using a Rich data type (I am not sure if I said it correctly) from B2 to a variable.
I tried to convert it into text or string and it does not work. I assigned the variable as a Variant and String, but still, it won’t work. Error is saying “Run time error’13’ Type mismatch. But I cannot figure out where I did wrong.
I googled around and I cannot find an answer. Is it possible though?
[ad_2]