View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
ilia ilia is offline
external usenet poster
 
Posts: 256
Default finding charcters for UDF

I'm getting 3/8, in Excel 2007, using this procedu

Public Sub test()
ActiveCell.Value = ChrW(&H215C)
End Sub

On Jan 22, 8:54*pm, John wrote:
I have this line in my UDF which worked in excel 2003 and I seem to be having
trouble in excel 2007...

If eigth = 3 Then
* * * * TYfrac = root & "-" & fracint & "" & ChrW(&H215C)
* * * * End If

Can ChrW be referenced the same way???