How to use "Transpose"?
 

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

How to use "Transpose"?
 

Application.Transpose(MyArray)

--
Regards,
Tom Ogilvy


"Michael" wrote in message
om...
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

How to use "Transpose"?
 

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

Mike


*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!

How to use "Transpose"?
 

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

--
Regards,
Tom Ogilvy

"Michael Sultan" wrote in message
...

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

Mike


*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!

How to use "Transpose"?
 

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.

--
Regards,
Tom Ogilvy


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

--
Regards,
Tom Ogilvy

"Michael Sultan" wrote in message
...

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

Mike


*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!