print one address

Here's my macro as far as I could go.
It prints the entire spreadsheet with the word "To" in the left most cell, next to a name, then moves down a cell and repeats. I want to define the print area as one line at a time with the word "To" next to it.

Please Login or Register  to view this content.

I'm not sure how to handle this. I posted my question here, then realized it should be in another section and posted it there. Sorry.
You asked me to post the "work book". I am guessing you want to see what my worksheet looks like, so here it is. The entire range is B1:D17

From 654


First Name1, Last Name1 404
First Name2, Last Name2 123
First Name3, Last Name3 456
First Name4, Last Name4 789
First Name5, Last Name5 331

Etc.

Your post did not comply with Rule 3 of our Forum RULES. Use code tags around code. Posting code without them makes your code hard to read and difficult to be copied for testing. Highlight your code and click the # at the top of your post window. For more information about these and other tags, found here

I have added the code tags in your post, please read the rules and use the code tags in future.

Originally Posted by Nazerith

if you can attatch the Workbook you have to your thread so I can see what you want to do I can better help you. I'm having a hard time following your intent.

I want a copy of sheet 1 for each person on sheet 2 list. I want to print copies of sheet 1 on one side, then flip and re-insert the sheets in the printer and print single address on othe side. Then I will fold the sheets with address on outside and give them to our mail room.

Thanks