Counts how many cells matching 2 criterias.
Just like
Wed 7AM
Show or hide item (or items) in PivotTable for a certain field. Passing ...
Jan23
Shows or hides an item or items in a PivotTable filter field. Passing ...
Jan22
Assign certain keyboard shortcut to certain macro, or clear that shortcut. ...
Dec13
Adds databars conditional formatting to range of cells. Passing column, start ...
2022Aug22
Selects a shape inside sheet to change it, or if not found, it will create it ...
2022Jul21
Counts how many items selected in a listbox (multi-selection listbox). Works ...
2022Apr21
Fills in more rows at end of a range Used to add more rows at end to have all ...
2022Mar11
Unmerges all merged cells and duplicate cell contents into them. In another ...
2019Apr16
Convert text blocks (by converting line separators from any separator to any). ...
2018Jul11
Show number of characters in a textarea and limit if it goes greater than ...
2018Jul5
Set of functions to generate Bootstrap controls as strings. Controls available ...
2018Jun24
Counts how many cells in a column in any sheet, any workbook using COUNTIF ...
2018May23
Set of functions to manage ANStrList strings, read, save, delete, sort, compare, ...
2018Apr14
Counts number of image files found in a folder Images defined here are files ...
2018Nov25
Asks user to select an image and returns full path and name of selected image ...
2020Dec19
Replaces the background fill of any shape in Excel with an image Not Ready yet, ...
2021Mar27
Reads image dimensions, width, height, depth and image type. Details returned ...
Jan16
Loads an image into VBA image control without knowing its extension If file ...
2018Jul7
Searches for an image and return the file extension of found, or returns null ...
2019Dec7
Gets most recent N files from a given folder. Uses Arrays, and the function ...
2018Oct1
Pure ASP Classic barcode generator This is one of my past findings, I will be ...
2020Feb1
Gets images in a folder where filenames start with "User" Similar to function ...
2019Dec31
Counts how many cells matching 2 criterias.
Just like
Wed 7AM
Listing the file from a folder that was created during last few hours. Can ...
Tue 7AM
Finds the location of a sting inside list of strings with certain separator, or ...
Apr23
Import all CSVs found in a folder into sheets, sheet per CSV This was a quick ...
2021Oct5
Reads file and showing it as Bootstrap row, with ability to replace variables ...
2020Dec15