PRINT COLUMN A:A

[scottie1]

Morning folks

I have a quick question I have a list in column A:A I want to be able to print ONLY it's content with borders round only the contents. The number of rows is different for eack job but I don't want to be printing out 65536 rows. Iwant to be able to put the code on a command button inbeded into the sheet.

Cheers

Scottie1

Roast Dinner

 

[PHV]

Have you tried to play with the PageSetup.PrintArea property ?

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244

 

[scottie1]

When i try it on a different job it keeps trying to print what the last job was. Say I had to print 50 rows in first job thats fine but if the next job is 40 it will try to print of 50 rows

 

[PHV]

Do a search in FAQ area for lastrow

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244