LastRow = ActiveSheet.UsedRange.Row + ActiveSheet.UsedRange.Rows.Count

CE


Den 21.08.2013 12:20, divya nila skrev:

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.