help with a transpose please

[scottwilsonx]

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

 

[Tom Ogilvy]

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