Roman number series (macro)
Closed
Caines87
Posts
1
Registration date
Wednesday April 27, 2011
Status
Member
Last seen
April 27, 2011
-
Apr 27, 2011 at 10:37 PM
RWomanizer Posts 365 Registration date Monday February 7, 2011 Status Contributor Last seen September 30, 2013 - Apr 28, 2011 at 03:50 AM
RWomanizer Posts 365 Registration date Monday February 7, 2011 Status Contributor Last seen September 30, 2013 - Apr 28, 2011 at 03:50 AM
Related:
- Roman number series (macro)
- Best scandinavian crime series on netflix - Guide
- Spell number in excel without macro - Guide
- Audio track download for series - Guide
- Xbox series x 3d blu ray - Guide
- Hitman 3 cheats xbox series x - Guide
1 response
RWomanizer
Posts
365
Registration date
Monday February 7, 2011
Status
Contributor
Last seen
September 30, 2013
120
Apr 28, 2011 at 03:50 AM
Apr 28, 2011 at 03:50 AM
Use the following macro :
Once the custom series added you can delete the codes.
Sub CustomRomanSeries() Dim i As Long On Error Resume Next For i = 1 To 4100 Range("A" & i).Value = WorksheetFunction.Roman(i) Next i Application.AddCustomList ListArray:=Range("A1:A3999") End Sub
Once the custom series added you can delete the codes.