"Jim Cone" wrote in message ...
John,

I do not know why you are getting the error in the Transpose line.
However, you do not need to use Transpose as you can write the PasteRange
values into ReturnVals and eliminate the need to transpose it.
By the way Range("AP7:AP469") has 463 rows not 462.
Try something like...

Thanks Jim! Copying the needed data into a 2-d array worked out great!

-John