Here is the code to do it

With ActiveSheet.PageSetup
.CenterFooter = "Page &P"
End With

I assume you know to put the code in a module.
"Anupam Soral" wrote:

How can thru programming we can get page number within an excel worksheet
--
Anupam