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).

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).