Tom, thank you for posting your reply.
I have tried the VBA you sent me:

Option Explicit
Sub TransposeTweek()
Dim vArr As Variant
Dim rw As Long
rw = 1
vArr = Application.Split(Worksheets("sheet1").Cells(rw, 1).Value, "/")
Worksheets("Sheet2").Range("A1:A900").Value
Application.Transpose(vArr)
End Sub

When I ran the macro, I got the message: "Object doesnt support thi
property or method".

Any idea why this would happen? and is there a way to get round this ?

Thanks
Scott

--
scottwilson
-----------------------------------------------------------------------
scottwilsonx's Profile: http://www.excelforum.com/member.php...fo&userid=1112
View this thread: http://www.excelforum.com/showthread.php?threadid=27237