For Each loop doesn't take every row into account

**Tino XXL** · 10-15-2012, 05:30 AM

Hi

I'm working on a macro in which I want it to delete every row in which the value of the cell in column A matches the value of fixed cell "I1".

Partially my code works, however it doesn't take every cell in the range in to account. It skips every other row.

Can anyone of you guys pls help me out with this one?

Greetz,
Tino

Code used:

Please Login or Register  to view this content.

**thisisgerald** · 10-15-2012, 05:45 AM

@tino

please see attached.

**JosephP** · 10-15-2012, 06:02 AM

Your post does not comply with Rule 3 of our Forum RULES. Use code tags around code. Posting code without them makes your code hard to read and difficult to be copied for testing. Highlight your code and click the # at the top of your post window. For more information about these and other tags, found here

**AB33** · 10-15-2012, 06:06 AM

value of fixed cell "I1". I can not see this value in I1

**Tino XXL** · 10-15-2012, 06:11 AM

Ok Joseph, I knew I had to do something with the code but didn't know exactly what anymore.

I'm sorry, this won't happen again.

Greetz,
Tino

**Tino XXL** · 10-15-2012, 06:15 AM

Originally Posted by thisisgerald

@tino

please see attached.

Hi,

Thank you very much for your quick reply, this is exactly what I was looking for.

Greetz,
Tino

**Tino XXL** · 10-15-2012, 07:49 AM

Hi

Just to complete this. I got this to work just fine for me using a do...loop.

The code I used replacing the For each loop is:

Please Login or Register  to view this content.

**thisisgerald** · 10-15-2012, 07:54 AM

Originally Posted by Tino XXL

Hi

Just to complete this. I got this to work just fine for me using a do...loop.

The code I used replacing the For each loop is:

Please Login or Register  to view this content.

Yes, basically this one will also works.

Regards,
thisisgerald

For Each loop doesn't take every row into account

LinkBack

Thread Tools

Rate This Thread

Display

For Each loop doesn't take every row into account

Re: For Each loop doesn't take every row into account

Re: For Each loop doesn't take every row into account

Re: For Each loop doesn't take every row into account

Re: For Each loop doesn't take every row into account

Re: For Each loop doesn't take every row into account

Re: For Each loop doesn't take every row into account

Re: For Each loop doesn't take every row into account

Thread Information

Users Browsing this Thread

Tags for this Thread

Bookmarks

Bookmarks

Posting Permissions