Home |
Search |
Today's Posts |
#2
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
DTPicker to be dropped down on initialisation | Excel Programming | |||
String array issues. Need help... | Excel Programming | |||
How to avoid re-initialisation when Unloading form | Excel Programming | |||
Passing a String in Array to Range as String | Excel Programming | |||
Convert a string to an array | Excel Programming |