Dim T as string
I run my code, and stop it, then I try to see what the value of my variable "T" is... This is from the immediate window in the VBA editor in Excel:
? asc(T)
63
? chr(63)=T
False
? len(T)
1
What am I not seeing?
Variable value???
-
- BronzeLounger
- Posts: 1254
- Joined: 03 Feb 2010, 19:59
- Location: Terneuzen, the Netherlands
-
- Administrator
- Posts: 78545
- Joined: 16 Jan 2010, 00:14
- Status: Microsoft MVP
- Location: Wageningen, The Netherlands
Re: Variable value???
If T is a Unicode character > Chr(255), Asc(T) will return 63 and Len(T) will return 1, but T will not equal Chr(63).
Best wishes,
Hans
Hans
-
- BronzeLounger
- Posts: 1254
- Joined: 03 Feb 2010, 19:59
- Location: Terneuzen, the Netherlands
Re: Variable value???
OK, so how do I test if T is that value?
-
- BronzeLounger
- Posts: 1254
- Joined: 03 Feb 2010, 19:59
- Location: Terneuzen, the Netherlands
Re: Variable value???
ASCW, sorry... found it, thanks