TheWennerWoman
Active Member
- Joined
- Aug 1, 2019
- Messages
- 270
- Office Version
- 365
- Platform
- Windows
Hello everyone.
To find the last row of data I have always used
This works fine. However, I have a situation where column A (starting at A4) will contain "Post" (via a formula based on other cell contents). There might be five of these (A4 thru A8), there might be fifty thousand (A4 thru A50003); however, at some point "Post" will become "Do Not Post".
I want to find the last row in column A containing "Post", I am not interested in "Do Not Post".......is there a quick hack to the above code I can use?
Many thanks for your time as always.
To find the last row of data I have always used
Code:
Dim lastrowup As Long
With ActiveSheet
lastrowup = .Cells(Rows.Count, "A").End(xlUp).Row
End With
This works fine. However, I have a situation where column A (starting at A4) will contain "Post" (via a formula based on other cell contents). There might be five of these (A4 thru A8), there might be fifty thousand (A4 thru A50003); however, at some point "Post" will become "Do Not Post".
I want to find the last row in column A containing "Post", I am not interested in "Do Not Post".......is there a quick hack to the above code I can use?
Many thanks for your time as always.