Components 190
Controls, objects and classes, also cells, sheets, workbooks in VBA-Excel
Sorted from new to old.
Match5_5thNot0 and Match6_6thNot0
Searches for 4 cells in 4 columns then checks for 5th column to not equal zero ...
ANmAddress_Dimensions
Detects how many dimensions an address has, This is what I call it dimensions ...
CountColumnCells_Unique
COunts unique cells found in a column. Passing sheetname, workbook name and ...
ANmAdd_ThenSort_2Columns
Adds values of 2 cells into 2 columns (usually below them). I used these small ...
ListBox bug with TabIndex
Setting TabIndex for a listbox to 0 in a Userform will have some issues when ...
CopyDynamicRangeValue
Copy values from range to cell. Without using clipboard of course. Here the ...