Convert list to UPPER, lower & Proper cases.

  • Thread starter Thread starter L. Howard
  • Start date Start date
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
 
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
Upper, Lower & Proper case 2
Code copies ONLY last j from sheet 9
Array coding type mismatch 6
Macro doesnt work properly 2
Select Case Code does not run... 10
Select Case code error 8

Back
Top