activex add page number

Hello,

Is there a way to add the page number in an excel document with activex ?

Thanks,

R

Answer 1

[Shuba Nandini]

Hi,

It is my understanding that you would like to add page number to the Excel Sheet. You can use "PageSetup" object with "CenterFooter" property to set the page numbers for the each sheet using the following command:

activeWorksheet.PageSetup.CenterHeader = "Page &P of &N"

I hope this helps!