print mutiple lines macro

[phillyd023]

I am learning VBA (still in early baby stages of it). I need to create a macro that does the following:

select sheet 1
copy row 2
select sheet 2
paste in cell a1
print the sheet 2

I need the macro at this point to go back to sheet 1 and do the exact same thing for row3, then row 4 etc. At times there may be a different number of rows on sheet 1 so the macro would either need to calculate how many lines of info there are so it knows how many times to run or maybe a pop up window asking the user to input the number of times the macro will run.

[Fluff13]

How about

Please Login or Register  to view this content.

[phillyd023]

I forgot to say thanks for this, Fluff13, thanks!!!

I have another question …. I have created a new instances where I want to utilize your above VBA macro, however, I need to have another macro run in the middle of it. meaning, the macro would still copy the information from sheet1 and copy in sheet2, but then some other macro work would be done before it prints ………… then repeat.

is there a way to insert another macro into what you gave me? by either saying "run macro "macronamehere" or just pasting my vba info in between 2 lines of your macro?


Thanks

[Fluff13]

You can add the line in red & change the macro name to suit

Please Login or Register  to view this content.