>Dear Sir,
>
>All above Codes WorK fine, Now here is another question
>
>How to insert Custom Footer, I want to insert Page X of Y at Bottom Right.
>
>Please Help
Something like:
loSheet.PageSetup.RightFooter = "Page &P of &N"
not tested
Against Stupidity the Gods themselves Contend in Vain - Johann Christoph Friedrich von Schiller
The only thing normal about database guys is their tables.