![]() |
#1
|
|||
|
|||
![]() Graham Mayor's site has the following macro, for converting non-autotext fractions to fractions. I can't get it to work on any fraction. VBA points to a problem in the line TypeText Text:=sFraction(1) Would someone let me know the correction required, please? Code:
Sub FmtFraction() Dim sFraction() As String Dim sChar As String 'Check if a fraction is selected 'and if not show a warning and exit If InStr(Selection, "/") = False Then MsgBox "No fraction selected!", vbCritical, "Format Fraction" Exit Sub End If 'Define a new slash character sChar = ChrW(&H2044) 'Split the original fraction at the slash character sFraction = Split(Selection, "/") 'Reformat the fraction using super and subscript With Selection .Font.Superscript = True .TypeText Text:=sFraction(0) .Font.Superscript = False .TypeText Text:=sChar .Font.Subscript = True TypeText Text:=sFraction(1) .Font.Subscript = False End With End Sub |
|
![]() |
||||
Thread | Thread Starter | Forum | Replies | Last Post |
![]() |
gsrikanth | Excel Programming | 1 | 07-12-2012 07:40 AM |
![]() |
markg2 | Word | 5 | 01-31-2011 01:58 PM |
Macro to open template not working | Brandi | Mail Merge | 2 | 06-24-2010 09:29 AM |
fraction not appearing correctly | kcr | Word | 1 | 10-21-2009 03:51 PM |
Word 2000 Macro not working properly | brianlb | Word VBA | 1 | 07-01-2009 07:04 AM |