vba help: footer with count of rows in the page.

[vlsmithika]

Hi,

how to print number of rows in each page in footer. second page should have total number of rows till second page and third page should have total number of rows till then and so on.

how can i do this. should there be a vba macro or can we do this by simply calling a cell reference in excel. please help.

Thank you.