I'm getting an overflow error in a statement that simply counts a numberof rows. The statement worked before with a smaller data set (the new one has 63000 rows).

numberofRows = ActiveCell.CurrentRegion.Rows.Count

numberofRows is dim'd as an Integer

What can I do about this, please?


Thanks

Jim Berglund