Search results 68

Sorted from new to old.

ANStrVLookup

behaves as vlookup to return item from 2-dim ANStr Can choose which column, ...

2025Jun14

MatchIf8

Searches for 8 cells in 8 columns and returns the row number if all found. Has ...

2025May10

VBInstr_Rev_Any

Finds first match of string inside another in reverse order. From right to left ...

2025Apr11

ANmAddress_Dimensions

Detects how many dimensions an address has, This is what I call it dimensions ...

2024Nov8

MaxOfArray

Gets the maximum number from an array. Like

2024Oct24

CutString12

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

2024Aug22

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

UniqueRandomID in SQL

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

2024Feb18

VBInstrRev

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

2024Jan24

1 2 3 4 5