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