Copying cells from varying rows

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a table set up and would like to copy the cells to another worksheet,
creating a different printout for each row's cells. How can I set up the
worksheet to use the contents for just row 1, for example, print out my
results, and then move on to row 2?

Thanks in advance,
 
sub printrows
for i = 1 to 44
rows(i).printpreview 'change to printOUT

next i
end sub
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel Copy cells from one worksheet to another workseet - increment row & do again 0
Copy a range data from 1 sheet to multiple selected sheets 1
Excel Moving data to sheet2 from sheet1 0
Selecting all cells with content using a variable 3
Excel VBA 1
Add a new row in Named Table (Table1) and add data from txtboxes into last empty cells based on header named of the Table1 0
Summary Worksheet. 1
How to copy data from certain cell in one tab to another tab 1

Back
Top