Codes recently updated
New versions for codes, updated recently by our developers. 24 most recent codes.
ANStrList functions v4
Set of functions to manage ANStrList strings, read, save, delete, sort, compare, ...
Sun 7AM
SettingRead+SettingSave v4
This is the final version of my set of Setting functions SettingRead, ...
Sun 6AM
WorkbookOpen_ANmar v4
Opens Workbook without running AutoMacros and without letting the user know ...
Sat 6AM
Match5_5thNot0 and Match6_6thNot0 v2
Searches for 4 cells in 4 columns then checks for 5th column to not equal zero ...
Tue 5AM
FixPath, IsThere, IsThere1 ... v11
Set of 6 functions to deal with filesystem. Gets current workbook path, ...
Jan26
MatchIf (aka VMatchIf) v2
The best Match I created, return 0 if not found, kind of CountIF+Match ...
Jan23
CopyDynamicRangeValue v3
Copy values from range to cell. Without using clipboard of course. Here the ...
Jan13
ANmaPivotTable_Clear v2
Clears all filters in PivotTable and hide the [blank] item from list, pass ...
Jan13
PivotTable_ShowHideItems v2
Show or hide item (or items) in PivotTable for a certain field. Passing ...
Jan13
PivotTable_ShowHideBlankItems v3
Shows or hides an item or items in a PivotTable filter field. Passing ...
Jan13
HMatchIf_Multi v4
Returns column if an item from list of items was found in a row. Similar to ...
Jan13
URLs2Anchors v3
All links found inside a string into anchor (< a href=...) BUG!: Currently ...
Dec26
NumberBeforeString v3
Cuts a number that would be found before certain word inside a block string. ...
Dec26
Excel-VBA Limits v5
These are some limits I found during my work in Excel-VBA For more of Excel ...
Dec26
BodyYoutubeLink2iframe v3
Creates youtube embed from link Converts a youtube video link into a youtube ...
Dec22
SendEmailMsgv2023 v3
Sending email using Microsoft 365 account. Edit 2024-12-19: Fixing ability to ...
Dec19
SheetTabColor v3
Applies certain color to sheet tab in Excel. ColorNumber is Excel ColorIndex. ...
Dec16
Range22DimArray v3
Imports a range into 2-dimension array. Returns the array, providing range, ...
Dec10
Range_SaveAsImage v2
Exports range to an image, something we wanted to be able to do for a while now. ...
Dec10
LastRow_Remove v2
Removes last row in a table starting certain cell. Creating and using this ...
Dec4