Claus and I outnumber you about using a userform with labeled input
fields. This will be easier for the user as well as less prone to error
if commas are not in the right places! You can input directly from each
field via event code -OR- validate each field's data via a button click
when done.

Much easier to manage data without any ambiguity, with or without using
an array to write to the sheet. If using an array you can store the
field's index in its 'Tag' property and myArr(CLng(.Tag)) to load its
value.

--
Garry

Free usenet access at http://www.eternal-september.org
Classic VB Users Regroup!
comp.lang.basic.visual.misc
microsoft.public.vb.general.discussion