Similar codes
FilterSheet_1By1 + FilterSheet_Clear
Sets Autofilter in a sheet, and another function to clear Autofilter ...
2020Jan3
SumOf_3Filters
Returns sum of certain column in range (or table) in sheet after applying ...
2021Jan29
ANmaPivotTable_Clear
Clears all filters in PivotTable and hide the [blank] item from list, pass ...
Dec22
RemoveDuplicates
Removes duplicated items from a 1-dim array into new array, does not modify ...
2022Jul7
CopyFormat
Applies format into a cell (or range) from another cell. Can apply from any ...
2018Aug10
Recently by developer
CountColumnCells_2Criteria
Counts how many cells matching 2 criterias.
Just like
Wed 7AM
Files_FoundHours
Listing the file from a folder that was created during last few hours. Can ...
Tue 7AM
ANString_Location
Finds the location of a sting inside list of strings with certain separator, or ...
Apr23
Random Codes
Custom Excel Right-Click Menus
Customizing Excel's right click menus The following code demonstrates how to ...
2020Mar21
Paging with Alternating Colors
This script will take the results of a query and sets up number of records per ...
2018Apr18