Hi all

I posted this on the "Worksheet Functions" section which I believe, i
this instance, is the incorrect section. Hence I am now posting i
under this section.

I have a worksheet where I have both left and right header and foote
with the left margin set to 1cm for both the header and the footer.

With this set up, I notice that whilst the print area prints from th
specified left margin of 1 cm from the edge of the page, the text i
the header and the footer do not print from the same specified margi
of 1 cm from the edge of the page but prints from some distance furthe
left - which I presume is the default setting, presumably 1.27 cms!

I would like to be able to change this setting either from the fron
end functionality or using VBA code so that the print range and th
left header and footers print from the same specified left margin.

Ideally, I would prefer to be able to do the same both for left an
right headers and footers, if possible.

Any suggestions?


Best regards



Deepak Agarwa

--
Message posted from http://www.ExcelForum.com