Hi

Copy the cellsPaste SpecialTranspose.

If you are using XL2003 or lower, then your column of cells can't be greater
than 256, otherwise it won't transpose.

--
Regards
Roger Govier



"AAD" wrote in message
...
I want to take a column of numbers and instead of them being in a vertical
line, make them across the top without cutting and pasting each individual
cell is there a function to do this?