Recommended header when hiding multiple columns?

[david.j.winfield]

I have a single excel sheet that I have to use to create multiple
reports by hiding specific columns (I have to use a single sheet, I
cannot create multiple sheets and just link them together).

Some of the reports need different headings such the report title and
some other misc. info.

I was wondering what the best way to include the different header info
for each report. I tried just putting some of the things in the
columns that will show for each report, but some of the columns are
displayed on multiple reports.

I tired using text boxes, but if I put borders around them and try to
line them up they appear correct on the screen but do not print
correctly. I suppose I could always remove the borders then the
alignment wouldn't be as noticeable when printed. Is there any
another solution for creating a header/title blocks that handles
column hiding and that I can hide when necessary using VBA?

Thanks,
David

 

[Tom Ogilvy]

If you are going to use VBA to set up the report, why not just write the
appropriate information in the appropriate location for each report.

the other suggestion would be to write the headers in separate rows at the
top and hide or unhide these rows as appropriate. Assumes column A would
always be visible and if no other entries are in the row, the text would
"bleed" across.