Split shouldn't have Application. in front of it. Not sure how I typed
that. Must have been thinking ahead to application.Transpose.

--
Regards,
Tom Ogilvy


"scottwilsonx" wrote in message
...

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 this
property or method".

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

Thanks
Scott.


--
scottwilsonx
------------------------------------------------------------------------
scottwilsonx's Profile:
http://www.excelforum.com/member.php...o&userid=11128
View this thread: http://www.excelforum.com/showthread...hreadid=272376