AutoFit Problem

[kellyka]

Hi All,

I have a couple of worksheets which i enter data in, and in the sheets where i have more data i autofit the certain columns and rows, This works fine

I have also Footer and Header in the worksheets, but when i now print the worksheets the Footer and Header have all different sizes.

Any idea how do i get the Footer and Header all in the same size independent from the AutoFit value??

Thanks.

[Palmetto]

Use the built-in header and footer feature for the worksheet instead of using cells.

For each sheet, go to the the Page setup options, select the Header/Footer tab in the dialog and fill-in per your requirements.

[kellyka]

Hi Palmetto,

you're right, but than you have to do it manually,
i want to do it in a macro so the one who opens the file dont need to configure the zoomfactor.