Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Hey all
I have 2 arrays called arr1 and arr2 (string arrays) arr1 contains the values 1, 2, 3 arr2 contains the values a, b, c I have a third array, namesarr (also String), which contains the names of the first 2 arrays I am trying to have the following output on my excell sheet arr1 1 2 3 arr2 a b c Here is the code I am using: For S = 0 To UBound(namesarr) ActiveCell.Value = namesarr(S) For Each element In Array(namesarr(S)) ActiveCell.Offset(1, 0).Select ActiveCell.Value = element Next element Next S here is what I get: arr1 arr2 The contents of each of my arrays don't get printed. I am sure that I am referencing them incorrectly, but I can't figure it out. any help appreciated. Thanks Al |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Referenceing worksheets in excell 2003 | Excel Discussion (Misc queries) | |||
indirect function referenceing changing file name | Excel Worksheet Functions | |||
cross referenceing data in excel | Excel Discussion (Misc queries) | |||
Excel 2003 - referenceing the active worksheet page in vlookup | Excel Worksheet Functions | |||
Array Question | Excel Programming |