Similar codes
GetColumnName, ColumnName_XOffset
Gets the column name from a cell address. Returns "E" from "E45", or "BR" from ...
2018Jun15
CellRead (SimpleLookup)
Simply reading a value from a specific cell from a sheet from a workbook ...
2018Jun25
FilterSheet_1By1 + FilterSheet_Clear
Sets Autofilter in a sheet, and another function to clear Autofilter ...
2020Jan3
ReNumber_IDColumn_inTable
Reset numbers in ID column, with help from AI. The StoredProcedure will move ...
Dec17
RowList_Matching
Returns list of rows numbers having cells matching text in a column. Passing ...
2021Dec27
Row_PixelLocation
Gets the cell row where a certain shape is located by passing shape.Top number ...
2021Feb2
FormulasFlatten
Fill in formulas from 1st row, then convert them to flat values to avoid Excel ...
2018Jun30
CountColumnCells + CountColumnCells_Criteria
Counts how many cells in a column in any sheet, any workbook using COUNTIF ...
2018May23
Recently by developer
ANString_Location
Finds the location of a sting inside list of strings with certain separator, or ...
Tue 8AM
SettingSave + SettingRead for NumberFormat
Reads or applies certain NumberFormat to cell in settings. Same patterns as ...
Apr19
ANmaCellFormat
Reads or set Numberformatting for a cell or range. Can pass sheet and workbook ...
Apr18
CopyFields_FromTo
Moves strings within cells into other cells, move or copy. Specific task to ...
Apr17
Random Codes
Between_HTMLtag
Returns the full text found between HTML tag open and close by either and index ...
Jul22
IntlIsAlphaCharacter
Test if a character is alphanumeric, regardless of the code page or language ...
2020Mar21
eMailMe (CDO)
Single asp file (having function) to send an email It is used here to send an ...
2019May3
ANStrColor2RGB + RGB2ANStrColor
Converts R:G:B into RGB value (as long) and RGB from long into R:G:B
2018May30