Printing header question "Bri" <bdorr[ at ]idirect.ca> 28.01.2006 13:15:36 Greetings a) How do I put the contents of a cell into the header? (will vary from worksheet to worksheet) b) I'm sure I'm missing something obvious, but where do I set the LEFT and RIGHT header margins? (I can only find top and bottom) I'd like them to be the same as the L and R margins for printing the main body of the document. Thank you Bri

Re: Printing header question "David McRitchie" <dmcritchie_xlmvp[ at ]verizon.net> 29.01.2006 19:35:42 Hi Bri, a) you will need to use a macro b) you can not control margins of header For macros to change the headers see http://www.mvps.org/dmcritchie/excel/pathname.htm specific for a cell value to header or footer http://www.mvps.org/dmcritchie/excel/pathname.htm#celldata --- HTH, David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001] My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm Search Page: http://www.mvps.org/dmcritchie/excel/search.htm "Bri" <bdorr[ at ]idirect.ca> wrote in message news:eCI6vzAJGHA.532[ at ]TK2MSFTNGP15.phx.gbl... [Quoted Text] > Greetings > > a) How do I put the contents of a cell into the header? (will vary from > worksheet to worksheet) > > b) I'm sure I'm missing something obvious, but where do I set the LEFT and > RIGHT header margins? (I can only find top and bottom) I'd like them to be > the same as the L and R margins for printing the main body of the document. > > Thank you > Bri > >

Re: Printing header question "Bri" <bdorr[ at ]idirect.ca> 30.01.2006 15:37:36 Great advice and link references Thanks, Bri