Select rows that contain specific terms in the last column using VBA

Dear Experts:

I got a huge table (the only one) in the active document.

This table features the term 'Set' or 'Single Products' in the last column hundreds of times.

I now would like to be able to select all the rows where these terms occur in one go, ie. there will be hundreds of  selected noncontiguous rows after running the VBA macro.

Help is much appreciated. Thank you very much in advance for your kind help.

I have attached a sample file for your convenience. Regards, Andreas
Andreas HermleTeam leaderAsked:
Who is Participating?

As far as I Know Word Vba doesn't support it

Andreas HermleTeam leaderAuthor Commented:
Ah, ok, thank you very much for your swift support. I got a workaround for it, so that is not a big problem for me.

Nevertheless, thank you very much for it.
Andreas HermleTeam leaderAuthor Commented:
Hi Rgonzo,

yes you are totally right, there is no VBA solution for this, a google search produced the same results.

Anyway, thank you very much for your swift help. Regards, Andreas
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.