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
....
Assuming the information you want as your header is in row 1 go to File>Page
Setup. Go to the Sheet tab and select the button next to "Rows to repeat at
top:" then click on row 1. Push Enter then click OK. If I understand your
question correctly this should give you the results you're looking for.
Want to reply to this thread or ask your own question?
You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.
