Find Last row in the current page layout

[mirology]

I want to find the last row in the last used page in page layout preview ( empty or not ) ...

For example the last row in page 1 = 58 , Page 2 = 119 ... so on

So if i have 2 Pages and my last data entered is in row lets say 100 ... i need the lastrow to be 119 not 100 ... any ideas using VBA?

 

[hoyinsk8]

Try using this

dim i as long '
i= "yourworksheet".usedrange.rows.count
so i should be the last row of your worksheet

 

[mirology]

That Gives the 100 not the 119 .... it gives the last row of entered data