VBA code not working

[jmklei0]

I have a short code to see if each cell in the Parcel# column is empty. If there is nothing in the cell, the word "Deleted" should appear in the Status column in the same row. I'm looking for a reason this is not working. I've tried .formula instead of .value also. It seems like this is right to me. Thanks!

fyi: table1 is declared earlier in sub.

Please Login or Register  to view this content.

[modytrane]

from the part you've posted [without looking at rest of it], it seems like your are exiting For loop after first match.
Why do you need to Exit For loop without completing it?

[jmklei0]

Definitely don't need it if it's not supposed to be there. Just new to VBA.

[Rick Rothstein]

Please Login or Register  to view this content.

I believe all of the above code (assuming the Exit For has been removed) can be replaced by this single line of code...

Please Login or Register  to view this content.

[jmklei0]

I believe all of the above code (assuming the Exit For has been removed) can be replaced by this single line of code...

Please Login or Register  to view this content.

This could work if I changed my original goal to say "deleted" in the search (Parcel) column, but it was actually to say it in the Status column instead.

Nonetheless, I appreciate your help. But, a) this code doesn't work even though I tried it and looked up more about the Replace variable and b) I'm tired of failing at this line and moved on to a different approach, which does accomplish my goal.

Thank you. The conversation could continue to help others in the future, though.

[Rick Rothstein]

This could work if I changed my original goal to say "deleted" in the search (Parcel) column, but it was actually to say it in the Status column instead.

Whoops! A bad reading of your question on my part.

Nonetheless, I appreciate your help. But, a) this code doesn't work even though I tried it and looked up more about the Replace variable and b) I'm tired of failing at this line and moved on to a different approach, which does accomplish my goal.

Thank you. The conversation could continue to help others in the future, though.

To continue the conversation, I believe the following would work for you...

Please Login or Register  to view this content.

[jmklei0]

That's excellent help. Thank you Rick. The Evaluate function seems great but will need to check it out even more. This did exactly what I needed.