Search results 207

Sorted from new to old.

ColorTextbox_Partial

Set part of textbox to certain color, starting from certain character found in ...

Thu 3AM

ANmExcel_Replace

Replace text in cell using Excel built-in Replace function. Ability to do ...

Jul10

ANmaFormatLastRow

Format last row found/added in Excel range to certain color. ColorText is the ...

Mar26

Range().top below hidden rows

Hidden rows change the .top of below ranges. It turns out that the range().top ...

Jan13

ANStrColor2RGBA_Para

Returns Red, Green, Blue and Transparency from text representing color Like ...

2025Dec20

Create Tree from 3 columns (Sheet2Tree)

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

2025Aug7

ANStrVLookupAll

Retuns list of all matchings after doing vlookups to return item from 2-dim ...

2025Jun14

ANStrVLookup

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

2025Jun14

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

BoldCodeColor

Bold the first letter and color it based on Bootstrap color theme, info, ...

2025May26

FilesIn_4Array

Returns list of file names along with path, date modified and size in array of ...

2025May25

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

ANmaUploadFTP_FilesFrom2Columns

Upload files in column each to folder in next column. Expects to have two ...

2025May4

MatchIf7Up

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

2025May3

1 2 ...12 13