Steve wrote:
Is it possible to assign a single name to a
range (all related cells within a column, for instance B2 thru B6), then
tranpose that range into a row.

Yes, if you name B2:B6 as Start then enter into the row of 5 cells, as an
array formula using Ctrl+Shift+Enter:
=TRANSPOSE(Start)



Bill Manville
MVP - Microsoft Excel, Oxford, England
No email replies please - respond to newsgroup