![]() |
#9
|
||||
|
||||
![]()
Try this code. It assumes your cursor is in a cell you have already populated and then asks for how many tickets to add. It makes sure there are enough cells remaining in the table and then duplicates the current cell contents into the required cells.
Code:
Sub AddTickets() Dim i As Integer, iCount As Integer, celSrc As Cell, celAdd As Cell Dim rngCell As Range, rngToEnd As Range, aTbl As Table Set aTbl = Selection.Tables(1) Set celSrc = Selection.Cells(1) Set rngCell = celSrc.Range rngCell.MoveEnd Unit:=wdCharacter, Count:=-1 Set rngToEnd = rngCell.Duplicate rngToEnd.End = aTbl.Range.End iCount = InputBox("How many tickets do I need?", "Ticket Copier", 2) If iCount > 1 Then Do While rngToEnd.Cells.Count < iCount aTbl.Rows.Add rngToEnd.End = aTbl.Range.End Loop Set celAdd = celSrc.Next For i = 2 To iCount celAdd.Range.FormattedText = rngCell Set celAdd = celAdd.Next Next i End If End Sub
__________________
Andrew Lockton Chrysalis Design, Melbourne Australia |
|
![]() |
||||
Thread | Thread Starter | Forum | Replies | Last Post |
Saving Avery Label 8376 | fsinclaire | Word | 1 | 04-30-2022 09:12 AM |
![]() |
reneemettrie | Word VBA | 6 | 01-10-2020 12:03 PM |
![]() |
rainandwind_95448 | Word | 2 | 12-13-2015 08:05 AM |
![]() |
Clueless in Seattle | Word | 2 | 03-31-2015 06:15 AM |
Having trouble using Avery 4014 label to print multiple pages | Dickie | Mail Merge | 1 | 09-29-2013 07:28 PM |