Search results 60

Sorted from new to old.

RangeValues

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

2024Jan25

PivotTable_ShowHideItems

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

2024Jan23

PivotTable_ShowHideBlankItems

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

2024Jan22

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

Parts-File2Page

A classic ASP include file to read txt file of list into a page using bootstrap ...

2019Oct6

Bootstrap Select

Multi-select drop-down in Bootstrap with customization From

2019Sep16

1 2 3 4