Not without creating 3 print jobs.

One for each sheet to be printed.


Gord Dibben MS Excel MVP

On Fri, 28 Dec 2007 06:58:02 -0800, igbert
wrote:

Would anyone knows how a marco to insert different cell content as header
onto different worksheets within a workbook?


For Example

Sheet 1 : use Cell A1 as header
Sheet 2 : usse Cell F2 as header
Sheet 3 : use Cell M5 as header

Igbert