| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
cell contents into an array
i have a column with acct #s in it. each cell can have multiple accts. they are
separated by a comma. how do i get these into an array so i can access each acct # as an element? i tried using arr=array(range("E3").value, but it created 1 element with the 3 acct #'s. tried to use split, but it only brought in the first one. there may be only 1 acct #, there may be 15 in ach cell. -- Gary |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| does an array contain contents of cell | New Users to Excel | |||
| #N/A if cell contents not part of an array | Excel Discussion (Misc queries) | |||
| How can I Import picture contents into Excell cell array numbers? | Excel Worksheet Functions | |||
| Can you fill an array from the contents of a single cell | Excel Programming | |||
| use cell reference,whose contents= a table array name for Vlookup | Excel Worksheet Functions | |||
Threaded Mode
