dpaton05
Well-known Member
- Joined
- Aug 14, 2018
- Messages
- 2,352
- Office Version
- 365
- 2016
- Platform
- Windows
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
Can someone help me please?
I can't just use "the address".select as the page may change.
I tried this code
VBA Code:
Sheets(Sheets.Count + 1).Top.Row.Select
Can someone help me please?