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....
Search:Type: Posts; User: peertje888 Search: Search took 0.01 seconds.
Results 1 to 1 of 1
|
Click Here to Expand Forum to Full Width |