View Single Post
 
Old 08-07-2022, 05:19 PM
littlepeaks littlepeaks is offline Windows 10 Office 2010 32bit
Novice
 
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