Thread: String array initialisation
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Piotr Lipski Piotr Lipski is offline
external usenet poster
  
Posts: 36
Default String array initialisation
Dnia 29 Jun 2006 12:21:48 -0700, napisał(a):

Dim VarNames

dim r as excel.range, strtmp as string
for each r in range("k22:k32").cells 'btw, that's 11 cells, not 10
strtmp = strtmp & switch(strtmp="", "", true, ";")
next r
VarNames = split(strtmp, ";")

There is probably someting better, but I always use this.

--
PL
Reply With QuoteReply With Quote