| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
finding charcters for UDF
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??? |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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??? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Finding the top 10 | Excel Discussion (Misc queries) | |||
| What are the Charcters "{}" used for | Excel Discussion (Misc queries) | |||
| Selecting 10 charcters on one cell and pasting to another cell | Excel Programming | |||
| percentage return on charcters not numbers | Excel Worksheet Functions | |||
| Trim special charcters from start of string | Excel Programming | |||
Linear Mode
