WorksheetFunction.CountA vs end(xlUp) (finding last row)

  • Re: WorksheetFunction.CountA vs end(xlUp) (finding last row)


    I don't know about speed, but CountA has the issue that if you have blank cells, it will provide the wrong answer.

  • Re: WorksheetFunction.CountA vs end(xlUp) (finding last row)


    End is fractionally faster in my tests, but probably not fast enough to make much of a difference:


    Results:

  • Re: WorksheetFunction.CountA vs end(xlUp) (finding last row)


    thank you guys hehe


    it makes a huge difference for me hehe


    i need to find the lastrow for over 9000 (no pun intended) different columns lol

  • Re: WorksheetFunction.CountA vs end(xlUp) (finding last row)


    I don't see how it does, I found the last row for 10,000 items above and the difference between the two is indistinguishable in real terms.

  • Re: WorksheetFunction.CountA vs end(xlUp) (finding last row)


    oh nvm then lol... i didnt look at ur code closely, i thought that was like per column or something.....
    besides, the fact that countA skips blank cells kinda killed it...

Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!