Codes recently updated

New versions for codes, updated recently by our developers. 24 most recent codes.
{{$CodeName$}
Match5_5thNot0 and Match6_6thNot0 v2

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

Tue 5AM

ANmarAmdeen
{{$CodeName$}
Match2 v4

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

Sun 10AM

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

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

Sun 9AM

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

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

Thu 3PM

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$}
NumberBeforeString v3

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

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
{{$CodeName$}
SortArea4 v2

Sort range of cells by up to 4 columns. Can use any of these columns, not ...

Dec19

ANmarAmdeen
{{$CodeName$}
SendEmailMsgv2023 v3

Sending email using Microsoft 365 account. Edit 2024-12-19: Fixing ability to ...

Dec19

ANmarAmdeen
{{$CodeName$}
SheetTabColor v3

Applies certain color to sheet tab in Excel. ColorNumber is Excel ColorIndex. ...

Dec16

ANmarAmdeen
{{$CodeName$}
RangeValues v2

Returns values of all cells in range into 1 string Only non-blank values ...

Dec16

ANmarAmdeen
{{$CodeName$}
Range22DimArray v3

Imports a range into 2-dimension array. Returns the array, providing range, ...

Dec10

ANmarAmdeen
{{$CodeName$}
Range_SaveAsImage v2

Exports range to an image, something we wanted to be able to do for a while now. ...

Dec10

ANmarAmdeen
{{$CodeName$}
LastRow_Remove v2

Removes last row in a table starting certain cell. Creating and using this ...

Dec4

ANmarAmdeen
{{$CodeName$}
Export2CSV v2

Exports a sheet into CSV file Dynamically finds number of rows/columns and ...

Dec4

ANmarAmdeen
{{$CodeName$}
CutString96_NumberX v2

Extract a full number from string block having 1 or more full numbers. Like ...

Dec4

ANmarAmdeen
{{$CodeName$}
CountColumnCells_2Criteria v2

Counts how many cells matching 2 criterias. Just like

Nov24

ANmarAmdeen