copying a column reference into a row

Giganews Newsgroups
Subject: copying a column reference into a row
Posted by:  lars1028
Date: Mon, 19 Jun 2006

I have a worksheet (sheet1) with a column of numbers (B2:B121). I would like
to reference these numbers on another worksheet (sheet2) but come over into a
row. I've tried using =sheet1(B2:B121), but I can't get these numbers to go
horizontally in a row.

Replies