MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Formulas in headers?


Posted by Paul B on January 27, 2002 6:29 PM

Can you put a formula in a header, ex. =sheet1!A1, and have it show what's in cell A1 in the header? I am using Excel '97. Thanks


Posted by Ivan F Moala on January 27, 2002 6:48 PM

Not without VBA (NT) post if still interested

Posted by Paul B on January 28, 2002 4:06 AM

Ivan, VBA will be fine (NT)