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

Scattered array cells copy to scattered array cells another workbook 14
Tried and true copy code lines fail me here 7
Code copies ONLY last j from sheet 9
Upper, Lower & Proper case 2
Array coding type mismatch 6
Array code only works on selected sheet 14
Macro problems 2
macro probs 4

Top