View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Les Les is offline
external usenet poster
 
Posts: 240
Default Help with Array & Split

Hello all,

I have a form that has data that the user enters with respect to a part
number, i have a radio button that if the user selects then he can enter
multiple part numbers, seperated by a comma ",". All the other data remains
the same.
What i am trying to do and really battling with is to split the numbers by
"," and then for every number i would like to start a new line and insert all
the data in a spreadsheet. What i had in mind was an array with a split
function, but not sure if i am thinking in the right direction.


Any help would be much appreciated.
--
Les