Similar codes
AskForFolder
Asks user to assign a folder, been looking for something like this for awhile ...
2023Mar23
Excel user name
Get application user name or change it
Originally from
Jun14
EmailSend_Outlook
Send email using Outlook object with attachments With AI-generated post image. ...
2023Apr5
SwapNumbers
Swap two numbers variables without using third variable A trick worth saving ...
2022Oct17
FilterSheet_1By1 + FilterSheet_Clear
Sets Autofilter in a sheet, and another function to clear Autofilter ...
2020Jan3
Freeze table head
Freezing head (thead) of a table when scrolling. Needed this feature for a ...
2019Sep5
Recently by developer
CountColumnCells_2Criteria
Counts how many cells matching 2 criterias.
Just like
May1
Files_FoundHours
Listing the file from a folder that was created during last few hours. Can ...
Apr30
Random Codes
Import error log
Imports the SQL Server error log into a table, so that it can be queried This ...
2018Sep29
MatchIf (aka VMatchIf)
The best Match I created, return 0 if not found, kind of CountIF+Match ...
2018Jun16