Print data in footer using _BeforePrint
 

I would like print data in the footer of a worksheet.

A previous question on this forum

"Is there a way to manipulate the footer in such a way that eac
successive page printed has a different alpha-numeric number in th
footer. This number would be related to the data on each page e.g. i
could be cell A20 for page1 , cell A40 for page 2, etc."

gave me the way to do this but required a button on the Excel sheet.

Can it be done using the Workbook_BeforePrint command - so that I don'
have to create a new print window to print a selection of pages (or onl
one page) and also maintain the Excel print preview

--
Hans4
-----------------------------------------------------------------------
Hans47's Profile: http://www.excelforum.com/member.php...fo&userid=1760
View this thread: http://www.excelforum.com/showthread.php?threadid=38475