How to determine Last row of a Page in Excel

[divya nila]

Hi,

I want to add Page border (for four sides) around each page in the spreadsheet of excel. My excel is having multipages in one spreadsheet and it is having nearly 6 spreadsheets. I have used PageBreaks to determine last row of a page but the pagebreak is 0 if i have only one page in a spreadsheet. So i want to know how to determine the last row of a page.

Thanks in Advance.

[patel45]

do you mean Last used row ? in this case

Please Login or Register  to view this content.

[divya nila]

No i mean the last row of a page not the last row with data.