Get LastRow based on a series of columns ranges?

Hi Guys,

I know how to get the last row for columns, usedrange... etc but I don't know how to get the lastrow based on multiple column range

For example, find the last row between columns A:M but IGNORE N:O however we still want to check/get the last row for P:Z

Anyone know how to do this?

Please Login or Register  to view this content.

Originally Posted by mehmetcik

Please Login or Register  to view this content.

Doesn't work, see attachment

Originally Posted by xladept

Did you try my solution?

Hmm, for some reason it didn't add your quote and my reply O_o

I posted "How do I get your solution to use multiple ranges, A:M;P:Z for example"

Please Login or Register  to view this content.

Doesn't work :/

I made the following which works, albeit kinda slow in comparison of what it could be.

Please Login or Register  to view this content.

Hi Hyflex,
maybe so

Please Login or Register  to view this content.