Keeping just the rows with specific word (BUT KEEP THE TITLE)

Kopko · #8 05-27-2017, 12:26 PM

Quote:

Originally Posted by Guessed

Try this version. If it works then we can look at speeding it up

Unfortunately, this version is not working.
Answering your question: yes, the documents are always consistent with this layout.

I noticed in this last code that the vector sRef is doing the job that is saving all the strings with the hyperlink.

But this line is never being executed:

Quote:

For Each aRow In aTbl.Rows
sTag = Split(aRow.Cells(1).Range.Text, vbCr)(0)
'Debug.Print sTag
aRow.Range.Font.Hidden = Not InStr(sRefs, sTag) > 0
Next aRow

I tried to move it to the final of this code but I'm not having success. Always get an error.

Again, thanks a lot for your help man! Someday I will be like you and help people with codes like you are doing!

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Open file which contains specific words in title	Nick70	PowerPoint	2	06-08-2016 06:55 AM
Formatting all tables in doc with specific word in title	jeffreybrown	Word VBA	2	05-01-2016 06:05 PM
Copying specific columns of a table to WORD and deleting rows	ffinley	Word VBA	5	12-07-2015 04:01 PM
Export calendar events from multiple calendars with specific title	rasmus	Outlook	0	02-06-2015 01:58 AM
Extracting specific rows	sbdk82	Excel	4	09-07-2014 10:24 PM