To answer your second question...

This will rename the first worksheet to 'Test'

Sheet1.Name = "Test"


"S G Booth" wrote:

How can I refer to elements in an array?
Say just the 1st 20, and paste the values into
"A1" of the activesheet, please?

What if there were less than 20 elements?

Regards.