ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Variant to String (https://www.excelbanter.com/excel-programming/275924-re-variant-string.html)

Chip Pearson
Variant to String
 
Use the CStr function.

--
Cordially,
Chip Pearson
Microsoft MVP - Excel
www.cpearson.com

"ThatFella" wrote in message
...
Is there a way to cast or coerce a Variant to String (to avoid the type
mismatch when passing a Variant where a String is expected)?
Thanks in advance.
--
ThatFella

Jim Cone[_3_]
Variant to String
 
Myrna,

Thanks,

Jim Cone
XX
'********************
Myrna Larson wrote in message . ..
PS: AIR, Charles Williams has code for a high-resolution timer on his web site. Look for it at

http://www.decisionmodels.com/index.htm


On 2 Sep 2003 20:52:45 -0700, (Jim Cone) wrote:

I know of at least three ways to do this, but I have never seen any
discussion as to which might be more efficient/faster. I tend to use
method (3), shown below, but could use some enlightenment...

-snip-


All times are GMT +1. The time now is 10:31 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com