Convert list to UPPER, lower & Proper cases.

[L. Howard]

Yes! Any time you 'dump' an array into a worksheet the target range

needs to match the size of the arrays for both rows & cols!



Range("F1").Resize(UBound(vData, UBound(vData, 2)) = vData

Okay, thanks.

H

 

[L. Howard]

Hi Garry,

Could you email me off forum please about an unrelated matter.
[email protected]

Howard