View Single Post
  #5   Report Post  
Ron Coderre
 
Posts: n/a
Default

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