Search results 60

Sorted from new to old.

MatchIf2Up

Search for 2 items in 2 columns starting from last row upword (Starting with ...

2024Apr29

MatchIfUp or MatchIfRev

Searching for an item in a column from bottom to top. Will search for item in ...

2024Apr8

ContainerHTMLTag_ReturnBlock

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

2024Apr3

NumberBeforeString_HTML

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

2024Feb1

RangeValues

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

2024Jan25

CutString9

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

2024Jan7

HTMLPadding_v2

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

2024Jan5

CutLeftNumber

Cuts the left part of string as long as it is number Keeps getting characters ...

2023Dec31

ANmaPivotTable_Clear

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

2023Dec22

ANStrFind_AndOrAdd

Checks if an item was found in list of items and return 1 if yes, 0 if not ...

2023Dec19

CopyDynamicRangeValue

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

2023Aug10

ANmaSQL_InsertStatement

Creates SQL INSERT statements from a table in Excel. Used to be executed to ...

2022Jul3

Range_SaveAsImage

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

2022Feb16

UI_2ValidationsUpdate

Apply validation on two cells, when a 3rd cell is changed When modifying a ...

2020May27

Custom Excel Right-Click Menus

Customizing Excel's right click menus The following code demonstrates how to ...

2020Mar21

ANmaRedirect

Simple redirecting function, used to direct users from one domain into another ...

2019Oct25

1 2 3 4