Codes recently updated

New versions for codes, updated recently by our developers. 24 most recent codes.
{{$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
{{$CodeName$}
CreateUniqueList v2

Create list of unique items from a column into another column This is similar ...

Nov22

ANmarAmdeen
{{$CodeName$}
ANmaRemoveDuplicates v2

Removes duplication in table in 1 or more columns using Excel ...

Nov22

ANmarAmdeen
{{$CodeName$}
CountColumnCells_Unique v2

COunts unique cells found in a column. Passing sheetname, workbook name and ...

Nov22

ANmarAmdeen
{{$CodeName$}
Match4_4thNot0 v3

Searches for three cells in three columns then checks for 4th column if not ...

Nov13

ANmarAmdeen