Search results 149

Sorted from new to old.

ANmaTable_FieldValue_Concat

Concatenates fields in certain row each with its header and returns the full ...

Jul26

Create Tree from 3 columns (Sheet2Tree)

Converts 3 columns in sheet into 3-generation tree using TreeView from Mscomctl. ...

2025Aug7

Outlook data files

Custom default location for Outlook data files. Tell Outlook to always store ...

2025Jun18

DBTableCol_Array

Reads 1 column from SQL DB table and return as 1-dimension array oConn object ...

2025May30

Add bulk rows to DB Table

Inserts multiple rows into DB table as whole Unlike

2025May27

ANmaDropdown Search

Shows drop down menu of matching items when user searches in textbox with ...

2025May13

UsedRange

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

2025May12

1st cell of sheet range

Returns the address of first cell in data in range, the very first cell of very ...

2025May12

MatchIf8

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

2025May10

MatchIf8Up

Searches for 8 cells in 8 columns and return the row number if all found Just ...

2025May7

MatchIf7Up

Returns row number having 7 values in 7 columns if all found. With option of < ...

2025May3

MatchIf7

Finds the row of 7 columns matching 7 values with options of < > <> and <= ...

2025May2

MatchIf4Up

Returns row of matching 4 values in 4 columns searching from bottom to top. ...

2025Apr12

DB Connection Drivers Test

Test connection to DB using different drivers to see which one works. You may ...

2025Mar12

HTMLTableRow_LastRowWithData

Retunes the row from bottom that has data (not blank or hidden)

2025Feb19

TrimLines

Remove all line breaks from text from a text. Not like

2025Jan31

1 2 ...9 10