How to use "Transpose"?

[Michael]

Hi everyone,

I have this small piece of VB code:

Dim con As Constraint
Dim CRngSolution As Range
Set CRngSolution = Workbooks(filename). _
Worksheets("PT").Range("SolOBJ")
CRngSolution.ClearContents

'Write down goal constraints
For Each con In vehicleModel.Constraints
If con.Name = "Goal_Cons" Then
CRngSolution(Cline, Aline).Value = con.Value
CRngSolution(Cline, Aline).Value =
Val(Left(CRngSolution(Cline, Aline).Value, 5))
End If
Next con

How can tell the VB code to put the values using "Transpose"?

Thanks,
Mike

 

[Tom Ogilvy]

Application.Transpose(MyArray)

 

[Michael Sultan]

Thanks, but where should I put it in the code?

Mike

 

[Tom Ogilvy]

I can't tell - I don't say anything that is obviously either an array or a
range that would need to be transposed.

 

[Tom Ogilvy]

err ... "say" should be "see"

I can't tell - I don't see anything that is obviously either an array or a
multicell contiguous range that would need to be transposed.