Search results 328

Sorted from new to old.

PivotTable_ShowHideItems

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

2024Jan23

Converts two bytes to long

Functions to convert two bytes to a numeric value (long), (both little-endian ...

2024Jan14

CutString9

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

2024Jan7

ChartLabelsNumberFormat

Apply Number format of 1 decimal to datalabels of specific series in certain ...

2023Dec23

ANStrFind_AndOrAdd

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

2023Dec19

Frequency1

Finds how many a string found inside larger string. Similar to Frequency but ...

2023Dec16

VBHTMLInstr

Searches for string in readable text from HTMLBlock. So it will not find what ...

2023Dec3

UserChanged_Log4

Adds date to column1 when user enters text in column2. Also, if user remove ...

2023Nov28

SearchinHTMLTable

Search for a word in a certain column in html table and return the full row ...

2023Nov12

Nearby Color shades

Calculate colors close to input color, a jquery html that will give you 10 ...

2023Nov8

AddressReferenceStyle

Change Address style from R1C1 to A1 or from A1 to R1C1. Something I needed ...

2023Nov1

HMatchIf_Multi

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

2023Oct30

Any2Dec

Converts a number of any base to decimal. Hexa to decimal, octa to decimal, ...

2023Sep20

SqlExec

Runs SQL Command that needs no return This is primarily useful for CREATE, ...

2023Sep3

NumberFoundinsideTag

Checks if a number found between two characters, searching can be customized to ...

2023Aug21

Arr_1Dim_2Str

Converts 1-dimension array into text. Meet Join. A way to convert array into ...

2023Aug14

1 2 ...7 ...20 21