asked on 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
Select-Noncontiguous-rows-VBA.docx
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
Select-Noncontiguous-rows-VBA.docx
Microsoft WordVBA
Last Comment
Andreas Hermle
ASKER CERTIFIED SOLUTION
THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
ASKER
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
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
Nevertheless, thank you very much for it.