ActiveSheet.Columns(2).Find("*", , , , xlByColumns, xlPrevious).Row
If B55 is blank (but with empty space), the code returns 55, which is NOT what I want. In this case, the last nonempty cell in Column B is above B55.
Thanks.
ActiveSheet.Columns(2).Find("*", , , , xlByColumns, xlPrevious).Row
If B55 is blank (but with empty space), the code returns 55, which is NOT what I want. In this case, the last nonempty cell in Column B is above B55.
Thanks.
Well to keep things simple you COULD use code to clear the cells that are not empty first then use the code you have.
Or you can give this a try.
If for example you want the last row in columns D:Q you could use the following.Please Login or Register to view this content.
Please Login or Register to view this content.
Please ensure you mark your thread as Solved once it is. Click here to see how.
If a post helps, please don't forget to add to our reputation by clicking the star icon in the bottom left-hand corner of a post.
Empty space with any character is not blank, hence excel thinks there is a value.
You can try this, but you might get the same result.
Please Login or Register to view this content.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks