Search results 377

Sorted from new to old.

Send workbook as email attachment

Retro way to send a workbook you are in as an email. Found it in one of my old ...

2024Feb14

Win10 ThisPC Virtual locations

I hate it when Windows forcing us to have additional items in "This PC" So, I ...

2024Feb5

HTMLTagID_Previous

Return id for any html tag that was found above certain location of html page. ...

2024Feb2

NumberBeforeString_HTML

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

2024Feb1

Random Number in SQL

Generate Random number inside SQL using timestamp (GetDate function) One of ...

2024Jan30

RangeValues

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

2024Jan25

VBInstrRev

Similar to VBInstr, but this one does it in reverse, which is instrrev() ...

2024Jan24

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

SettingRead_JSON

Reads certain value for a certain setting from FullJSONString text block. See ...

2024Jan8

FontAwesome Custom icons issue

I faced an issue the past few weeks when trying to add my own icon to ...

2023Dec29

ChartLabelsNumberFormat

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

2023Dec23

ANmaPivotTable_Clear

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

2023Dec22

ChartLegendCenter

Put chart legend at center of chart horizontally. Changes left and width only. ...

2023Dec21

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

1 2 ...6 ...23 24