Looks like you got your answer. Maybe another tip. When I am working with excel can't find a solution, I will record a macro and then look at the code that excel creates. Good Luck.

>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