Comparing two Arrays

[hopner]

Hi

I have made some code that works perfect, but i was wondering how you guys would speed it up a bit and simplify it. I couldn't figure out how to compare the to arrays DataRange and DRReal. Hope you can help me!

Please Login or Register  to view this content.

Moderator's note: Please take the time to review our rules. There aren't many, and they are all important. Rule #3 requires code tags. I have added them for you this time because you are a new member. --6StringJazzer

[6StringJazzer]

I couldn't figure out how to compare the to arrays DataRange and DRReal.

What is it you want to compare about them, and what action do you want to take as a result of the comparison?

I notice you have a couple of GoTo statements. I am a big opponent of those and will suggest an alternative once I understand your comparison issue.

In one case you have

Please Login or Register  to view this content.

But Icol will never be greater than 3. I don't know why you have that If/GoTo there.

[6StringJazzer]

Here is a streamlined version of your code, although it won't be any faster. I suggest you test it to make sure it still does the same thing. I can provide more help when I get your explanation.

Please Login or Register  to view this content.

[6StringJazzer]

Here is an even more streamlined version but still need to resolve your array comparison issue.

I have not tested this but would be happy to do so if I had your file.

Please Login or Register  to view this content.