hi, !

how do i insert page number on active cell?

AFAIK, what you need could suffer variations depending on non/controlled events
(i.e. changing page-setup/printer resolution/quality, pint area-titles, printing order, and so on)

i guess you could seek for options/alternates in the following pages:

Build Table of Contents, similar listings, working with Hyperlinks
http://www.mvps.org/dmcritchie/excel/buildtoc.htm

Build TOC Another Approach
http://www.mvps.org/dmcritchie/excel/buildtoc2.htm

regards,
hector.