Is there a way of getting Roman Numerals throug any font?
Is there a way of getting Roman Numerals throug any font?
This worksheet macro would convert numbers In Col A to Roman Numerals
or this link explains the formulaPrivate Sub Worksheet_Change(ByVal Target As Excel.Range) If Target.Column > 1 Then Exit Sub On Error GoTo ErrHandler Application.EnableEvents = False Target.Formula = Application.WorksheetFunction.Roman(Target.Formula) ErrHandler: Application.EnableEvents = True End Sub
http://exceltips.vitalnews.com/Pages..._Numerals.html
VBA Noob
_________________________________________
Credo Elvem ipsum etian vivere
_________________________________________
A message for cross posters
Please remember to wrap code.
Forum Rules
Please add to your signature if you found this link helpful. Excel links !!!
hey thanx that works well for me
Glad it helped
VBA Noob
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks