View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
[email protected] gdu@mldevices.com is offline
external usenet poster
 
Posts: 5
Default How to obtain superscript and mixed font info when read from Excel?

I am reading contents of an Excel file from a VB6 program. I need find
out the superscript and mixed font format info of each cell (such as
"Current Gain (A/cm2)", "Sheet Resistance (W/sq)", that 2 is
superscript and W is Omega in Symbol font). When I use, for example,
Range(strRange).Font.Superscript or Range(strRange).Font.Name, it
returns Null.

Any help will be greatly appreciated.