View Single Post
  #6   Report Post  
Posted to microsoft.public.excel.programming
Claus Busch Claus Busch is offline
external usenet poster
 
Posts: 3,872
Default Convert list to UPPER, lower & Proper cases.

Hi again,

Am Sun, 6 Apr 2014 02:22:18 -0700 (PDT) schrieb L. Howard:

It seems every time I try to write to an array my examples syntax don't fit the scheme I am dealing with.


if you want to redim an array in the code you have to declare it with
brackets:

Dim myArr() as variant


Regards
Claus B.
--
Vista Ultimate SP2 / Windows7 SP1
Office 2007 Ultimate SP3 / 2010 Professional