View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Bob[_77_] Bob[_77_] is offline
external usenet poster
 
Posts: 61
Default Displaying the infinity symbol in an excel spreadsheet

Hi Everyone:

I posted a similar message on the VB newsgroup, and got my answer for VB.
Now, I was wondering does anyone know how to display the infinity symbol in
the excel spreadsheet using VBA? I tried this code, but it did not work on
excel 2003.

Range("A1").Font.Name = "Arial"
w = "This is the infinity symbol: " & Chr(165)
Range("A1").Value = w
x = Len(Range("A1").Value)
Range("A1").Characters(Start:=x, Length:=1).Font.Name = "Symbol"

Thanks for your help.

Bob