how transpose range1 to compare to range2?

[reneuend]

I have 2 ranges of the same size, but one is vertical. Is there a way to transpose one so I can compare it to the other using VBA?

....or do I need to copy past one of them first using the transpose option?

thx for help!

 

[VoG]

You can use

Application.TransPose(range)

to go from vertical to horizontal

 

[reneuend]

Hi VoG,

I tried that but I'm getting an "Object Required" error.

I have 2 ranges. One is vertical the other is horizontal. Each have 6 values.

rRange1.Value shows the values when I add a Watch for it as vertical. rRange2.Value shows values also but as horizontal.

The following produces the error with application.transpose added. Am I using it wrong?

If rRange1.Value = Application.Transpose(rRange2).Value Then

 

[VoG]

You would need to loop through the ranges.

 

[reneuend]

Ok. Thanks VoG.