Skip loop if cells equal same values

**adam2308** · 07-01-2012, 02:32 PM

I currently have the code below that runs from row 4 in worksheet "Coupon" until it reaches the last last non-blank row.

Please Login or Register  to view this content.

I want to make a tweak to this so that it is more optimized, not doing unnecessary work any runs much more quickly. What I would like to do is to only run this part of the code

Please Login or Register  to view this content.

If the values in columns J and K are not equal to columns BB and BC. If they are then skip this loop and move on to the next row.

Does this all make sense?

**xladept** · 07-01-2012, 02:58 PM

Hi Adam2308,

Maybe:

Please Login or Register  to view this content.

**adam2308** · 07-01-2012, 03:57 PM

Thank you xladept.

Firstly, I changed

Please Login or Register  to view this content.

to all be on the same line as it was highlighted as red font and didn't seem to work this way. Let me know if I shouldn't have done this.

I then copied your code over mine and I am getting a "compile error: Variable not defined" and it highlights "J" in the line of code

Please Login or Register  to view this content.

**xladept** · 07-01-2012, 04:01 PM

Hi Adam 2308,

It's Ok to have it on one line but remove the colon and End If.

**adam2308** · 07-01-2012, 04:04 PM

Done that. So the line of code now reads

Please Login or Register  to view this content.

But still getting the same compile error message.

**xladept** · 07-01-2012, 04:08 PM

Have you put the GetNext procedure before the Next i?

**adam2308** · 07-01-2012, 04:13 PM

Still getting the same compile error without dots in ".range"

**xladept** · 07-01-2012, 04:18 PM

Please Login or Register  to view this content.

Try this line.

**adam2308** · 07-01-2012, 05:04 PM

ok, we have progress in that line of code now works but the code overall doesn't do what I was looking for.

I have attached a workbook to try and show you more clearly. If you click CommandButton2 then it will run the code we are discussing. Now, in this example, the code we changed should mean that only the first match (Arseanl v Bolton) on the 'coupon' is process because all the other matches have the same values in columns J & K as BB & BC. However, all matches are processed and copied on to the csv files created. The csv files on this example should only contain the Arsenal v Bolton match.

**xladept** · 07-01-2012, 06:48 PM

Hey Adam2308,

I tested your workbook and our code but by just testing the J vs BB values there were no matches in your sample.

BTW the .Range code works as well as the .Cells code on my machine - perhaps there was something else going on.

Here's how I tested it:

Please Login or Register  to view this content.

**adam2308** · 07-02-2012, 09:38 AM

Sorry, I gave you the wrong columns! It should have been H and I!!! Works perfectly now.

Note to self - Don't work on projects with an hangover!

**xladept** · 07-02-2012, 01:19 PM

Great, I'm glad to have helped.

Skip loop if cells equal same values

LinkBack

Thread Tools

Rate This Thread

Display

Skip loop if cells equal same values

Re: Skip loop if cells equal same values

Re: Skip loop if cells equal same values

Re: Skip loop if cells equal same values

Re: Skip loop if cells equal same values

Re: Skip loop if cells equal same values

Re: Skip loop if cells equal same values

Re: Skip loop if cells equal same values

Re: Skip loop if cells equal same values

Re: Skip loop if cells equal same values

Re: Skip loop if cells equal same values

Re: Skip loop if cells equal same values

Thread Information

Users Browsing this Thread

Bookmarks

Bookmarks

Posting Permissions