E2:E631091 and P2:P631091 are blank, at least they look blank. I expect LastRowE to be 1, instead LastRowE = 631091 , why?
It seems that when a cell = "", it is not really blank, although it looks like blank.
How to fix the issue? I want LastRowE to be 1 (only title row), not 631091. There is no data in E2:E631091
I think I need different code for LastRowE, maybe Rows.Count does not work correctly.
Please Login or Register to view this content.
Last edited by VAer; 03-20-2024 at 04:15 PM.
Do it like this:
In the absence of a Sample workbook, I created one.Please Login or Register to view this content.
Trevor Shuttleworth - Retired Excel/VBA Consultant
I dream of a better world where chickens can cross the road without having their motives questioned
'Being unapologetic means never having to say you're sorry' John Cooper Clarke
If a formula in a cell returns an empty string, and then you copy that cell and paste it as a value, the cell is only apparently empty.
You have at least 2 solutions.
1. you can use the following function to find the last non-empty cell:2. Before searching for the last non-empty cell using Range.End(xlUp), clean up the column (you can only do one at a time!) using the "Text as columns" functionality or the following macro:Please Login or Register to view this content.ArtikPlease Login or Register to view this content.
Thank you, all.
You're welcome.
If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED.
Also, you may not be aware that you can thank those who have helped you by clicking the small star icon located in the lower left corner of the post in which the help was given. By doing so you can add to the reputation(s) of those who helped.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks