How about turning things around and having a value in a cell (or cells)
on your worksheet that then forms the header for your report.
I'm not sure myself but this thread seemed to work OK for someone else
...

http://www.excelforum.com/showthread...ht=cell+header

Hope this helps


--
tonywig


------------------------------------------------------------------------
tonywig's Profile: http://www.excelforum.com/member.php...o&userid=18985
View this thread: http://www.excelforum.com/showthread...hreadid=379847