Use this
Code
-------------------
With ActiveSheet.PageSetup
.LeftFooter = "&D"
.CenterFooter = "&Z&F"
.RightFooter = "&P of &N"
End Wit
-------------------
--
Excelenato
-----------------------------------------------------------------------
Excelenator's Profile:
http://www.excelforum.com/member.php...fo&userid=3676
View this thread:
http://www.excelforum.com/showthread.php?threadid=56614