You are limited to 65,536 rows and 256 columns on a single worksheet. If you
run out of room, there's not much you can do other than continue on a new
worksheet, or switch over to using Access, which is designed to be used as a
database (unlike Excel).
