did you try to <transpose

highlight B2 to B20
edit copy
open anoher sheet and select a cell
edit pastespecial -transpose

is that not what you want.
==================
hughvision wrote
in message ...

Hi all,

I am trying to code a macro that uses a for each loop, for each cell in
say Row B going down, B2:B20 create a new column for each cell on
another sheet, with the same header... So basically taking everything
from a vertical set of rows and populating another sheet with all
columns (horizontal) instead...

If anyone has any ideas, please right back.

Thanks.

Hugh.


--
hughvision
------------------------------------------------------------------------
hughvision's Profile:
http://www.excelforum.com/member.php...o&userid=24660
View this thread: http://www.excelforum.com/showthread...hreadid=382389