Detecting Top of Page

Is there a way of detecting, when printing, that a cell is at the top of the page?

I am not talking about the automatic "Rows to repeat at top" option on Page Setup; I have programmatically suppressed repeating information in Column A but I want to repeat that information if the column is fed to a new page.

Try this in the Immediate window.

Please Login or Register  to view this content.

Thanks Andy. That gave me the hints I needed.

For the benefit of the wider Excel community, here is a function that I've written so that Excel may query itself directly from any cell as to whether that cell is at the top of a printed page:

Please Login or Register  to view this content.