Maybe this site will help you
http://support.microsoft.com/kb/273028
"dmanflan" wrote:
I want to take information contained in one worksheet and use it in the
header of another spreadsheet. When I'm in the header setup, I can't access
any cells or defined names. I figure there must be some way to do this in a
macro. Any ideas? The example would be tying customer names to their ID
numbers in a report generated from sales data (i.e., statements).