07 - Filter a table using a variable (VBA)
This picks up where video 06 leaves off: • 06 Hide worksheets on close (VBA)
The web page where I found the filter trick: https://www.ozgrid.com/VBA/autofilter...
00:00 - Picking up from episode 06
00:35 - Validating the entered data
01:00 - Data validation is better in base Excel
01:50 - Filtering on a date in VBA
02:15 - Remove existing filters
02:38 - Table filter-function is like VLookup
02:58 - Filter the table with a date variable
03:36 - Use the Format function to convert to a date
03:46 - Loop to unhide sheets
04:01 - Lazy error handling
05:16 - A full run
05:34 - The Close Workbook-macro to force macro activation
Watch video 07 - Filter a table using a variable (VBA) online without registration, duration hours minute second in high quality. This video was added by user WesleySon 05 April 2023, don't forget to share it with your friends and acquaintances, it has been viewed on our site 145 once and liked it 2 people.