Search results 72

Sorted from new to old.
Card image
VBA/Excel Registry hacks

Set of hacks to modify Excel/VBA settings using Windows registry (Regedit) ...

Card image
ANmaSafeDeleteFile

Deletes file safely without warnings or error messages. Tries to delete it at ...

Card image
Excel 2408 bug

Serious bug in Office update that was pushed Aug 26th. At least from Excel ...

Card image
Choose2

Returns a value based on an ID. If ID is 1, return 1st value, If ID is 2, ...

Card image
FindZipFile_WShell

Finds the first zip in a folder matching wild cards mask using WScript.Shell ...

Card image
FindImg_WShell

Finds the first image in a folder matching wild cards mask using WScript.Shell ...

Card image
MatchIf5Up

Searches for five cells in five columns and return the row number if all found ...

Card image
ANmaSearch_ApostropheFriends

Searches for string inside string with apostrophe variations conversion

Card image
MatchIF5

Searching for rows having 5 values in 5 columns Like

Card image
MatchIf2Up

Search for 2 items in 2 columns starting from last row upword (Starting with ...

Card image
SettingSave + SettingRead for NumberFormat

Reads or applies certain NumberFormat to cell in settings. Same patterns as ...

Card image
MatchIfUp or MatchIfRev

Searching for an item in a column from bottom to top. Will search for item in ...

Card image
DateDateDate

Finds three dates after each other in one paragraph. Needed to locate numbers ...

Card image
Install/Uninstall SQLNativeClient DB driver

Install/Uninstall SQL DB driver. SQLNCLI.msi that is needed when you do ...

Card image
Win10 ThisPC Virtual locations

I hate it when Windows forcing us to have additional items in "This PC" So, I ...

Card image
ReNumber_IDColumn_inTable

Reset numbers in ID column, with help from AI. The StoredProcedure will move ...