I want to create a macro in excel 2007 that allows me to set print area and then print it

Hi,
Can you please help me accomplish this macro. I want to set the print area from Column 12 to column 7, then print that area only. I want to be able to do it on any row in my table that has about 5,000 rows.

I do know how to press shift + home, then press the set print area button, then the print button, and it prints the row material I want. But I want to just create a macro that will do all this. Can you pleas help.

Thanks,
Cliff

I actually just had to do this myself today, if you could attach a sample I'm sure I could help

Thanks so much for your response. I tried it, but I must not have the columns numbered correctly. Here is a sample of the table I use set print area and prinr 7-17-14.docx.
Cliff

set print area and prinr 7-17-14.docxThanks so much for your response. I am attaching the sample of my Table I want to use. Hope this gets to you and this is what you need.
Cliff

Define the named Range as PrintStart, the rows you want repeated on each sheet.

Please Login or Register  to view this content.

Thanks so much for the help. This macro seems to work, but I only want to print the one customer's row of info and not the heading. It now prints heading, too. I will have over 5,000 rows and it will grow and be dynamic. Also, I need to be able to set the print area each time on each different customer.

Thanks again. I want one row to print G thru L only.

Remove the rows to repeat in the page layout settings and change this line.

Please Login or Register  to view this content.

Thanks again. I am not sure I follow. What do you mean "Remove the rows to repeat in the Page Layout settings". Tried Set PrintRange with G1 but now the Sub PrintAll() needs debuging?

In excel go to the page layout tab, then go to page set up. Go to the sheet tab and you'll see Rows to repeat at the top. If you still can't get it worked out upload a copy of the file and I can fix it for you.

I put this together, see if it suites your needs. Print.xlsx

Sample STRING TABLE TEST 7-119-14.xlsm
Thanks again for all your help. I have attached a sample of my file that I want to do a macro to set print area and print. I have narrowed my print area to G thru J. G is my start column. There are no columns to the left of G. I hope this explains it better. Can you see my attachment?
Cliff

Thanks so much. I will test it out shortly
Cliff Price

Thank you so much for your help. I have been using some pre set Excel button for a while. Can we expand what you gave me. I will be on the cell and row I want to print. I just want to press a button to set print area of the 3 cells in one dynamic row and then print it. Can you please help me with that. Now, I click on my cell in "K", then press Shift+Home, then press the "Set Print Area" button, then Press the "Print" button. It works, but is too many key strokes. Every time I try to do a macro. It won't repeat.
Thanks,
CliffDPrice

Thank you, Sorry I have been so slow in replying, but going a slower method of printing now. Trying again. This is what I want to print. I will be in Column K.
PRICE, CLIFF (column I) "(91x) 494-xxxx (91x) 664-xxxx" (Column I) 4/11/2015 WILSON TOUR 102 -U WSG #55(Column K)

I will have about 6,000 rows of individuals and their string jobs. When I am in current row of Column K after I have entered my stringing info will tab to Column L. I want to be able to press a button and it will set my print area of K, I, J in one row and print the selected row of text. Now I press Shift + Tab, Shift+Home, Press the Set Print Area button, then press the quick print button.
Thanks so much for your time.
CliffDPrice

Sorry but this is the correct columns headers

PRICE, CLIFF (column H) "(91x) 494-xxxx (91x) 664-xxxx" (Column I) 4/11/2015 WILSON TOUR 102 -U WSG #55(Column K)

Cliff