Why does a variant with a single value type convert to string?
I have filtered a list in another sub function, and then I want to parse out the values in column A. It works fine if there are multiple values, but when the variant "temp" has only one item, it becomes a string and I get Type Errors when it gets to the For/Next loop.
I tried to force it back to a variant with the red code, but it still comes out as a string!
Please Login or Register to view this content.
Variant is variable type. So variant temp can hold any given type.
Once temp is assigned some value/object type of variable held is implicitly set to that of the value/object.
What is the purpose of using CVar()?
If variable is declared as variant then you can use it below without issue. If it's declared as specific type, it can only hold value/object of that type.
Ex:
EDIT: Personally, I've never seen code or algorithm which required use of CVAR().Please Login or Register to view this content.
Last edited by CK76; 01-31-2020 at 12:05 PM.
"Progress isn't made by early risers. It's made by lazy men trying to find easier ways to do something."
― Robert A. Heinlein
rather than it's type check whether it's a single item or not.
To save duplicating your 'parse a bunch of stuff' put that code in another routinePlease Login or Register to view this content.
Oh, if you need to convert string to single item array.
Please Login or Register to view this content.
Thank you,
I'm new to VBA and I guess I didn't fully understand what a Variant is. Andy Pope's solution worked perfectly for me. Thank you all.
Edit: Thank you for the suggestion to convert to array, I think that was what I was trying to accomplish with CVar()
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks