Search results 362

Sorted from new to old.

UniqueRandomID in SQL

Generate new Random ID, unique not duplicated in two columns in two tables. ...

2024Feb18

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

1 2 ...5 ...22 23