Trouble getting macro to loop

[andre232]

Hello!

I have been trying for a few days to get this macro to loop. It needs to take info from page 1 and paste into specific areas on sheet 1 then print. I have it doing that much but I need it to do this for each row on page 1 until there is no more data. It is to print some very basic invoices. I have tried many variations with no luck. Any help or advice would be appreciated! Thank you.

Please Login or Register  to view this content.

Moderator's note: Please take the time to review our rules. There aren't many, and they are all important. Rule #3 requires code tags. I have added them for you this time because you are a new member. --6StringJazzer

[dmcgov]

can you attach a sample workbook? need to see a representative of what the source looks like

this is what your code looks like once it is streamlined

Please Login or Register  to view this content.

[andre232]

Yea sorry about the formatting. I think I attached a sample worksheet its not pretty but I think you'll be able to see what I'm going for. Thanks!

[dmcgov]

some questions for you. i added your macro to the workbook module and ran it. gave me errors.

which sheet is the active one when you run your macro? Also which cell is active.

what can you tell me about page1_1? how do you decide which row you will use?

maybe best way is to add a sheet that shows what you want it to look like before it is printed.

[sintek]

This should give you an idea...

Please Login or Register  to view this content.