unichar(9679) in VBA variant array variable

[BDrew]

I have a read activesheet.usedRange.value into a Variant array vUR and am walking the rows and columns to extract info based on criteria.

One criteria is: vUR(r, c) <> Unichar(9679)

I know that Unichar(9679) is a bullet character but this syntax to recognise it in a variant array is wrong.

Any ideas welcome.

Brendan

 

[BDrew]

I have a read activesheet.usedRange.value into a Variant array vUR and am walking the rows and columns to extract info based on criteria.

One criteria is: vUR(r, c) <> Unichar(9679)

I know that Unichar(9679) is a bullet character but this syntax to recognise it in a variant array is wrong.

Any ideas welcome.

Brendan

vUR(r, c) <> "=Unichar(9679)" compiles but vUR(r, c) at the appropriate array item returns "?"

Perhaps I should just replace all the bullets with something easier to handle

vUR(r, c) = "" avoids the whole issue because it is a bullet or nothing.

So, the real issue now is can this character be addressed in VBA at all?

 

[mikerickson]

How are you reading the array?
If you are using vUR = someRange.Value, then vUR does not contain the unicode values in the strings, but the ASCII values.

 

[Fennek]

Hello,

try:

chrW(9679)

regards

(dim By() as byte
by = cells(1,1).value
test for 2x asc())

 

[BDrew]

Thank you mikerickson and Fennek for you valuable inputs.

chrW(9679) works a treat and is certainly ASCII values.

Brendan