Search results 121

Sorted from new to old.

Match3_3rdNot0

Searches for two cells in two columns then checks for 3rd column if not equal ...

2024Nov2

MaxOfArray

Gets the maximum number from an array. Like

2024Oct24

CutString12

Cuts string between two numbers that found inside string. Like extract the ...

2024Aug22

ANstr_Column

Reads and concatenate the full HTML or non-HTML of column (ColumnID) from HTML ...

2024Jul29

Daily folder

Create daily folder in specific location automatically. I used to have .bat ...

2024Jul28

DateDiff_Networkdays

Calculates no of workdays between two dates. Option to use international ...

2024Jul25

Center Userform

Looks like forcing a Userform to be in center of an application is not as easy ...

2024Jul23

IfString_StartsWith_AndOr_EndsWith

Checks if String starts with certain char and ends with certain char Or one of ...

2024Jul18

ANmaSearch_QuoteFriends

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

2024Jul13

ANmAdd_ThenSort_2Columns

Adds values of 2 cells into 2 columns (usually below them). I used these small ...

2024Jun1

ANmaHTMLTables_Combine2

Combine strings of two HTML tables into string of one table. Edit 2024-10-31: ...

2024May16

CountColumnCells_2Criteria

Counts how many cells matching 2 criterias. Just like

2024May1

ListBox bug with TabIndex

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

2024Apr15

Between2int and Between2intinc

Checks if number between two numbers, with or without considering those numbers. ...

2024Mar23

Concatenate_HTMLColumn

Build a string from a certain column in html table (using < table, < tr, and < ...

2024Mar14

VBInstr_Numeric

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

2024Feb25

1 2 ...7 8