Activating a page just below the last data entered on my sheet so I can run vba on that page

[dpaton05]

I need to select a page that is just below the end of my pages that have data so that I can then run vba code to do things on that page but at the moment, when I try and run it I keep getting the error of subscript out of range. I am guessing it is not working as the page is all greyed out because there is nothing on it. This is talking about pages on a single sheet.

I can't just use "the address".select as the page may change.

I tried this code

Sheets(Sheets.Count + 1).Top.Row.Select

Can someone help me please?