Need print code please

Need print code please

Post by Rodder » Sun, 21 Sep 2003 03:09:25


Hi all

Could someone let me have some code to print a workbook down as far as the
last used row.

Thanks in advance
 
 
 

Need print code please

Post by Rodder » Sun, 21 Sep 2003 07:28:17

Thanks Tom - but I can't delete rows or columns - I guess maybe what I'm
trying to do is change the print area to go down only as far as a row with a
certain value in column A (for instance) and then print

Any ideas please?

Cheers






the

 
 
 

Need print code please

Post by Tom Ogilv » Sun, 21 Sep 2003 08:35:36

ActiveSheet.PageSetup.PrintArea = Range(cells(1,1),Cells( _
rows.count,1).end(xlup)).Resize(,10).Address(external:=True)
Activesheet.Printout




a