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

Guessed · #1 06-04-2017, 04:02 PM

To keep tables together, use styles which include the paragraph formatting "Keep with Next" turned on.

To force a date in the InputBox, do a google search "inputbox date validation" to view code samples like...
https://www.mrexcel.com/forum/excel-...alidation.html
https://social.msdn.microsoft.com/Fo...orum=vbgeneral

Kopko · #2 06-05-2017, 04:44 PM

Thank you buddy. I got it both running. The code is really awesome now.
I will keep ask you some questions, you can be free to ignore me whenever you want.

I followed your advice about the formatting and did this:

Code:

With Selection.ParagraphFormat
        .KeepWithNext = True
End With

But there is still a problem. The "Agente" title table sometimes is being left in one page and the table data in the other one.
What I thought to do is to merge the Table Agente with the data table below. I know this will require to change the structure of the code and I also don't know how hard can this change affect the whole code.

Could you give me a light again please?

Thanks!

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