Jim,

Try declaring numberofRows as long as an Integer type only goes to 32767.

Regards
Neil
"Jim Berglund" wrote in message news:bl%Kd.211825$Xk.154817@pd7tw3no...
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