Similar codes
SheetAdd_ANmar
Adds a sheet to a workbook, after checking if workbook is open Checks if ...
2019Apr1
ANmaPivotTable_Clear
Clears all filters in PivotTable and hide the [blank] item from list, pass ...
Dec22
Excel sheet textbox
Found a strange behavior for Excel sheet textboxes. Textbox in Excel sheet, ...
2020Feb22
CellRead (SimpleLookup)
Simply reading a value from a specific cell from a sheet from a workbook ...
2018Jun25
CountColumnCells + CountColumnCells_Criteria
Counts how many cells in a column in any sheet, any workbook using COUNTIF ...
2018May23
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
UISetup + UIRestore
Simple way to freeze UI in Excel-VBA then restore it after complete in standard ...
2022Jan28
CSS Hover effect
Pure CSS hover effect
From
2019Jun20
Fancybox iframe
This is to demonstrate how to call a Fancybox from inside an iframe into parent ...
2019Jan15
Open different Filestypes
Populate list of filetypes in Application.GetOpenFilename method. This command ...
2019Jan9