Two things:
1)Not sure how you're doing it now, but this should work:
Range("C" & CurrRow & ":V" & CurrRow).Select
2)Excel has 65,536 rows, but Integer variables max out at 32,767. You might
want to define currrow as Long (which goes somewhere past 2 million.
--
Regards,
Ron
|