![]() |
|
#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 |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| Saving Avery Label 8376 | fsinclaire | Word | 1 | 04-30-2022 09:12 AM |
Accessing the format tab with the macro recorder
|
reneemettrie | Word VBA | 6 | 01-10-2020 12:03 PM |
Avery Label Templates, editing rows/spacing
|
rainandwind_95448 | Word | 2 | 12-13-2015 08:05 AM |
Avery Label Template for Word 2003?
|
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 |