Codes recently updated

New versions for codes, updated recently by our developers. 24 most recent codes.
{{$CodeName$}
ContainerHTMLTag_ReturnBlock v3

Returns the full string starting from open tag of container where LocationIndex ...

Mon 1PM

ANmarAmdeen
{{$CodeName$}
HTMLPadding_v2 v9

Finds the padding or margin from a style statement for an HTML tag. Passing ...

Sat 12PM

ANmarAmdeen
{{$CodeName$}
CutString9 v3

Cuts from CutFrom starting from any of items found from ...

Apr10

ANmarAmdeen
{{$CodeName$}
TemplateLine_10Xs v2

Two functions to automate the replacing of variables inside a long string. Up ...

Apr10

ANmarAmdeen
{{$CodeName$}
NumberBeforeString_HTML v4

Cuts a number that would be found before certain word inside a block string. ...

Mar20

ANmarAmdeen
{{$CodeName$}
CopyRange_NoClipboard v2

Copies range without using clipboard. Applies formats into a cell (or range) ...

Mar13

ANmarAmdeen
{{$CodeName$}
Min_No0s v2

Getting the minimum number from an array excluding zeros. Edit 2025-03-11: ...

Mar11

ANmarAmdeen
{{$CodeName$}
CutString v6

Cuts a string from certain char till certain char, can be used to cut left, ...

Feb19

ANmarAmdeen
{{$CodeName$}
Match2 v5

Matching by two values at the same time in two columns Just like Match the ...

Feb3

ANmarAmdeen
{{$CodeName$}
ANStrList functions v4

Set of functions to manage ANStrList strings, read, save, delete, sort, compare, ...

Feb2

ANmarAmdeen
{{$CodeName$}
SettingRead+SettingSave v4

This is the final version of my set of Setting functions SettingRead, ...

Feb2

ANmarAmdeen
{{$CodeName$}
WorkbookOpen_ANmar v4

Opens Workbook without running AutoMacros and without letting the user know ...

Feb1

ANmarAmdeen
{{$CodeName$}
Match5_5thNot0 and Match6_6thNot0 v2

Searches for 4 cells in 4 columns then checks for 5th column to not equal zero ...

Jan28

ANmarAmdeen
{{$CodeName$}
FixPath, IsThere, IsThere1 ... v11

Set of 6 functions to deal with filesystem. Gets current workbook path, ...

Jan26

ANmarAmdeen
{{$CodeName$}
MatchIf (aka VMatchIf) v2

The best Match I created, return 0 if not found, kind of CountIF+Match ...

Jan23

ANmarAmdeen
{{$CodeName$}
CopyDynamicRangeValue v3

Copy values from range to cell. Without using clipboard of course. Here the ...

Jan13

ANmarAmdeen
{{$CodeName$}
ANmaPivotTable_Clear v2

Clears all filters in PivotTable and hide the [blank] item from list, pass ...

Jan13

ANmarAmdeen
{{$CodeName$}
PivotTable_ShowHideItems v2

Show or hide item (or items) in PivotTable for a certain field. Passing ...

Jan13

ANmarAmdeen
{{$CodeName$}
PivotTable_ShowHideBlankItems v3

Shows or hides an item or items in a PivotTable filter field. Passing ...

Jan13

ANmarAmdeen
{{$CodeName$}
HMatchIf_Multi v4

Returns column if an item from list of items was found in a row. Similar to ...

Jan13

ANmarAmdeen
{{$CodeName$}
URLs2Anchors v3

All links found inside a string into anchor (< a href=...) BUG!: Currently ...

Dec26

ANmarAmdeen
{{$CodeName$}
Excel-VBA Limits v5

These are some limits I found during my work in Excel-VBA For more of Excel ...

Dec26

ANmarAmdeen
{{$CodeName$}
BodyYoutubeLink2iframe v3

Creates youtube embed from link Converts a youtube video link into a youtube ...

Dec22

ANmarAmdeen
{{$CodeName$}
CreateAnchor v2

Creates an anchor by passing its arguments (used to be called URL2A), can ...

Dec20

ANmarAmdeen