Header space above text

  • Thread starter Thread starter Bill
  • Start date Start date
B

Bill

I have a macro that puts the filename less .xls (it is a
numbered file, i.e. 1234.xls) into the right header and
formatted to font 26. The problem is that it is close to
the top of the text. Is there a way to have the header
print closer to the top of the page, leaving the rest of
the page print in the same place. This macro is run on
several machines and changing top margins seem like a
problem.

Thanks
 
On the Margins Tab in the File-->Page Setup dialog, reduce the "Header:"
margin.
_______________________
Robert Rosenberg
R-COR Consulting Services
Microsoft MVP - Excel
 
Back
Top