Codes recently updated
New versions for codes, updated recently by our developers. 24 most recent codes.
Column1Range v2
Return range of cells in column having data where, ignoring header cell and ...
Sun 1PM
MatchIf6 v2
Searching for row have 6 matches found in 6 different columns, because we had 5, ...
Sun 1PM
MathInsideText v2
Return string after applying math to each number found inside the string. ...
Sat 3PM
NumberBeforeString_HTML v5
Cuts a number that would be found before certain word inside a block string. ...
Tue 7AM
NumberBeforeString_HTML2 v2
Cuts a number that would be found 2 words before certain word inside a block ...
Tue 7AM
ANmaRedirect v6
Simple redirecting function, used to direct users from one domain into another ...
Apr24
ContainerHTMLTag_ReturnBlock v3
Returns the full string starting from open tag of container where LocationIndex ...
Apr14
HTMLPadding_v2 v9
Finds the padding or margin from a style statement for an HTML tag. Passing ...
Apr12
TemplateLine_10Xs v2
Two functions to automate the replacing of variables inside a long string. Up ...
Apr10
CopyRange_NoClipboard v2
Copies range without using clipboard. Applies formats into a cell (or range) ...
Mar13
ANStrList functions v4
Set of functions to manage ANStrList strings, read, save, delete, sort, compare, ...
Feb2
SettingRead+SettingSave v4
This is the final version of my set of Setting functions SettingRead, ...
Feb2
WorkbookOpen_ANmar v4
Opens Workbook without running AutoMacros and without letting the user know ...
Feb1
Match5_5thNot0 and Match6_6thNot0 v2
Searches for 4 cells in 4 columns then checks for 5th column to not equal zero ...
Jan28
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