How about your SampleSize variable?
Does it return the expected number?
Also, what does the variable newbook return?

HTH
Cordially
Pascal

"NooK " a écrit dans le message de
...
I had already tried with Worksheets instead of Sheets but not Address
and I still get the same error. :(

Hopefully it is not a hopeless case.

Best Regards

NooK


---
Message posted from http://www.ExcelForum.com/