Integer data types have a limited size, and 65536, the last row on a worksheet, exceeds that limit. Try using the Long data type instead - similar to integers, but way bugger...

Col