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
- Xbox series x 3d blu ray - Guide
- How to zoom out on xbox series x - Guide
- Excel online macro - Guide
- Excel run macro on open - 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.
