i think i got it

--


Gary


"Gary Keramidas" <GKeramidasATmsn.com wrote in message
...
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