Search results 62

Sorted from new to old.

UnicodeToChrW

Converts a Unicode number into its ChrW text. It automatically uses surrogate ...

2025Jul17

UsedRange

Returns the address of first:Last cells with data in sheet. Like pressing ...

2025May12

Custom Excel UI ribbon

Excel custom ribbon in details. A good article I use as reference to add custom ...

2025May11

ANmaSearch_AllWords_FromANStr

Checks if string has all words from ANStr inside Retuns 0 if not found or ...

2025Jan8

VBInstr_Any

Search for string inside another, with ability to have multiple strings to ...

2024Nov15

Choose20

Chooses from 20 options based on the passed ID, can have any of these passed. ...

2024Sep5

Choose10

Choosing a return value based on an ID. Since we have Choose2, Choose3 and ...

2024Sep3

Choose2

Returns a value based on an ID. If ID is 1, return 1st value, If ID is 2, ...

2024Aug20

ListBox bug with TabIndex

Setting TabIndex for a listbox to 0 in a Userform will have some issues when ...

2024Apr15

Free online tools - convertcase.net

Bunch of online some text and image tools, helpful for most online users these ...

2024Feb15

FindLinks xla

Excel Addon to find links in workbook. FindLinks v13.2 From

2024Feb9

Random Number in SQL

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

2024Jan30

HTMLPaddingMargin_v2

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

2024Jan5

ANmaPivotTable_Clear

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

2023Dec22

ArrSort_5Arr and ArrSort_7Arr

2 functions to sort 5 Arrays or 7 Arrays respectively.

2023Apr23

File_SettingRead + File_SettingSave

Reads and saves settings to Settings file, used asp here. Similar to

2022Dec27

1 2 3 4