Hi,

I've just registered with Excel forum so this is my first thread.

I've been a user of excel vba for some time now and it is the first time I come accross this problem.

I am importing a file into an excel 'database' and after the formating, I set up my print settings (header, footer, zooming etc). For some strange reason everything works fine when I step into the macro with F8 but the header and footer doesn't work when I run the macro with F5.

Has anybody come across this problem?

Thanks
Costas