Search results 21

Sorted from new to old.

FirstDuplicatedItem

Returns the value of first duplicated item found in a range. This is to ...

2025Apr18

String_Fx

Generate repeated text, like String() the function but with ability to repeat ...

2025Apr10

DateAdd_Networkdays

Adds workdays to a date using DateAdd It keeps adding days and checks how many ...

2025Apr6

ListBox_Read and ListBox_Save

Reads or saves to a certain column in multi-column listbox in VBA Userform Can ...

2025Mar11

MaxOfArray

Gets the maximum number from an array. Like

2024Oct24

ANmaSearch_QuoteFriends

Searches for string inside string with double-quote possibility If single ...

2024Jul13

VBInstr_Numeric

Finds location of 1st numeric character inside string starting from a certain ...

2024Feb25

Import_CSV

Import the CSV file, DOES NOT OPEN, Open does not fix encoding issue, import ...

2018Jul7

CreateGUID

Generate random GUID of 36 chars (with or without brackets) using TypeLib ...

2018Jun25

CellHyperlink_ToSheet

Will add hyperlink in a cell to a sheet in same workbook Not Hyperlink ...

2018Jun24

InvertColor

Converts color into its negative value, as in "e4f15a" into "1C0FA6"

2018Jun20

DirsCombo_Read

Read directories in a specified folder into a combobox Needs FrmBr having Cbo1

2018Jun18

HaveNonEnglish + StringASCIIs

Checks if one char is within two ASCII codes or not (StringASCIIs) Used to see ...

2018Jun17

ScreenResolution_wxhxtxl

Detects active desktop screen resolution and location of taskbar (with some ...

2018Jun17

MatchIf_ThenDelete

Searches for an item in a column, then if found, delete that cell (not clear, ...

2018Jun17

Match4

Matching 4 values at the same time in 4 columns Just like Match the function, ...

2018Jun16

1 2