Hey, you can set a range as below:


Set rng = wks.Range("A1:I4000")

If you get an error that the range type is undefined, you have to check Excel in the "Refferences" from the "Tools" menu....