How to use "Transpose"?

M

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
 
T

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.
 
T

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.
 
Top