Thread: Keeping just the rows with specific word (BUT KEEP THE TITLE)
View Single Post
 
Old 06-04-2017, 04:02 PM
Guessed's Avatar
Guessed Guessed is online now Windows 10 Office 2013
Expert
  
Join Date: Mar 2010
Location: Canberra/Melbourne Australia
Posts: 4,176
Guessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant future
Default
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
__________________
Andrew Lockton
Chrysalis Design, Melbourne Australia
Reply With Quote