Convert list to UPPER, lower & Proper cases.

L

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
Click to expand...


Okay, thanks.

H
 
L

L. Howard

Hi Garry,

Could you email me off forum please about an unrelated matter.
(e-mail address removed)

Howard
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Search other sheets for numbers & color them 10
Open four Wbooks, copy four columns from each to Master Wbook 16
Array code only works on selected sheet 14
Upper, Lower & Proper case 2
Resize a row but copy but skip columns I don't want to copy 6
Copy Application.Union(c.Offset(0, 1), c.Offset(0, 2)... to a list onsame & another sheet 27
Macro adds "=" to each cell in defined range across multiple worksheets 5
Macro doesnt work properly 2

Top