Thread: [Solved] How to preset serial number in 00000# format
View Single Post
 
Old 03-26-2021, 01:59 PM
gmaxey gmaxey is offline Windows 10 Office 2016
Expert
  
Join Date: May 2010
Location: Brasstown, NC
Posts: 1,617
gmaxey is just really nicegmaxey is just really nicegmaxey is just really nicegmaxey is just really nicegmaxey is just really nice
Default
Code:
Sub ScratchMacro()
'A basic Word macro coded by Greg Maxey
Dim lngIndex As Long
  For lngIndex = 1 To 100000
    Debug.Print Format(lngIndex, "00000#")
  Next
lbl_Exit:
  Exit Sub
End Sub
__________________
Greg Maxey
Please visit my web site at http://www.gregmaxey.com/
Reply With Quote