If the functions in the freely downloadable file at
http://home.pacbell.net/beban are available to your workbook:

Range("A2:C28").Value = ArrayReshape(Range("A2:A81"), 27, 3)

Because A2:A81 is only 80 elements, the 81st element in the 27th row
will be 0.

Alan Beban

hef wrote:
I need to take a column that goes from a2:a81 and turn it into 27 rows
ie:
a
b
c
d
e
f

needs to be
a b c
d e f

etc...


------------------------------------------------
~~ Message posted from http://www.ExcelTip.com/
~~View and post usenet messages directly from http://www.ExcelForum.com/