![]() |
#5
|
||||
|
||||
![]()
Hi Teresa,
Assuming you already have your NCR sheets sorted, you could use a macro like: Code:
Sub PrintNCRSeries() Dim StrSeries As String, i As Long, j As Long, k As Long With ActiveSheet With .Range("F12") If InStr(.Value, "-") > 0 Then i = Split(.Value, "-")(1) + 1 j = Split(.Value, "-")(1) + 10 End If End With StrSeries = InputBox("What is the range to print? (eg 1-10)", _ "NCR Print Manager", Format(i, "0000") & "-" & Format(j, "0000")) If StrSeries = "" Then Exit Sub i = Split(StrSeries, "-")(0) j = i If InStr(StrSeries, "-") > 0 Then j = Split(StrSeries, "-")(1) For k = i To j .Range("F12").Value = "FE-" & Format(k, "0000") .PrintOut Copies:=3 Next End With End Sub
__________________
Cheers, Paul Edstein [Fmr MS MVP - Word] |
Tags |
ncr forms, numbering, numbering forms |
|
![]() |
||||
Thread | Thread Starter | Forum | Replies | Last Post |
forms | mrmagoo | Word | 2 | 06-28-2012 01:25 PM |
Forms | textboom | Word VBA | 0 | 02-23-2011 07:51 AM |
Document unique numbering / forms | JamesF | Word | 0 | 11-22-2010 03:52 AM |
Forms help | benji842 | Word | 0 | 06-24-2010 06:04 AM |
Forms | oo7juk | Word | 0 | 10-09-2009 01:55 AM |