M
MrNobody
I am using the following method to count the number of rows of data in a
column:
Worksheet.get_Range(A1:A1).get_End(Excel.XlDirection.xlDown).Row
And most of the time this works but sometimes it returns an un-godly number
like 65535 which screws everything up and takes forever...
Why does it do this and how can I fix it?
The column definitely 100% does not have nearly that many rows of data in it
column:
Worksheet.get_Range(A1:A1).get_End(Excel.XlDirection.xlDown).Row
And most of the time this works but sometimes it returns an un-godly number
like 65535 which screws everything up and takes forever...
Why does it do this and how can I fix it?
The column definitely 100% does not have nearly that many rows of data in it