Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #3  
Old 08-07-2022, 05:19 PM
littlepeaks littlepeaks is offline accessing avery label table in macro Windows 10 accessing avery label table in macro Office 2010 32bit
Novice
accessing avery label table in macro
 
Join Date: Jan 2012
Location: Colorado Springs, CO
Posts: 16
littlepeaks is on a distinguished road
Default

I want to copy the text from cell and paste it into other cells, as selected. I tried recording a macro, but when I copied the info from one cell, selected the next cell, and pasted, it just used an offset. And sometimes, the recorded macro didn't even run correctly. We are a nonprofit, and have a yearly raffle. For those who buy 20 or more tickets, we print out labels for them to paste on the tickets for the drawing, so they don't have to fill them out by hand. We use 1 sheet for several customers -- for instance I might have the first 20 going to one and another 25 labels going to another, etc. I would like to copy the data from cell into other selected cells. I could do this by using a loop, or using something like table.Cell(2,2).Range.Text = strTextCopied, but I can't seem to reference the table. I'd just like to try this as a learning experience. (TMI?)
Reply With Quote
 



Similar Threads
Thread Thread Starter Forum Replies Last Post
Saving Avery Label 8376 fsinclaire Word 1 04-30-2022 09:12 AM
accessing avery label table in macro Accessing the format tab with the macro recorder reneemettrie Word VBA 6 01-10-2020 12:03 PM
accessing avery label table in macro Avery Label Templates, editing rows/spacing rainandwind_95448 Word 2 12-13-2015 08:05 AM
accessing avery label table in macro 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

Other Forums: Access Forums

All times are GMT -7. The time now is 07:53 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2025, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2025 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft