Alan appears to think you want 7 rows and 611 columns for your result.

Maybe you should clear that up first.

In any event, go to the name box in the upper left corner of the formatting
toolbar (it has the address of the active cell in it) and put in

A1:A4276<cr
this will select A1:A4267

now go to the same box and enter

dataRange<cr

you can then go into Insert=Name=Define and you should see dataRange
listed. You can select it and see it is defined as

=Sheet1!$A$1:$A$4267

You could also create a name here by typing in the refers to (using absolute
references), then going to the Name area in the dialog and entering a name,
then clicking Add.

--
Regards,
Tom Ogilvy




--
Regards,
Tom Ogilvy

"RMorahn" wrote in message
...


"Alan Beban" wrote:

RMorahn wrote:
some one sent ma large file with seven recurring fields all in one
single
column. Is there some macro that will move each of seven rows to a
separate
column and then restart the process with each seventh line to the end
of the
file. There are too many items to do this manually? Each field item
recurs
every seven lines.
You will be limited by the maximum number of columns in the
spreadsheet--255.

One way: If the functions in the freely downloadable file at
http://home.pacbell.net/beban are available to your workbook, array
enter into a 7-row range of enough columns to accommodate the output

=ArrayReshape(dataRange,7,ROWS(dataRange)/7,TRUE)

Alan Beban


Thanks.

I need a little more help. When I past the command, do I enter it as html
or
unicode? I don't know how to name the data range of 4276 lines in column
a1.

Can you help me with that?