Compare column number of a cell with the last cell column number in a loop

Originally Posted by Marc L

Test with 65 536 rows. If success, test with one more row, aim is to find the row limit …

I have tried saving the data but it seems like the application hangs for even data that is equal or less than 65536 rows but it doesnt error out which means the code might be still executing.