Search results 27

Sorted from new to old.
Card image
ANmAddressSame

Checks if passed addresses are referring to same cell regardless of ...

Card image
ANmAddressRefStyle

Returns type of the cell address, A1 or R1C1 If multiple cells passed, the ...

Card image
ANmaCellChar_Superscript_Subscript

Sets certain character inside a cell as superscript or subscript

Card image
ANmaCellFormat

Reads or set Numberformatting for a cell or range. Can pass sheet and workbook ...

Card image
SortArea4

Sort range of cells by up to 4 columns. Can use any of these columns, not ...

Card image
SwitchTextinCells

Switch text inside cells with another text. This was needed to correct an bug ...

Card image
ANStrSort3

Sort list of texts having cell address by cell address as alphanumeric in Asc ...

Card image
Send workbook as email attachment

Retro way to send a workbook you are in as an email. Found it in one of my old ...

Card image
RangeValues

Returns values of all cells in range into 1 string Only non-blank values ...

Card image
AddressReferenceStyle

Change Address style from R1C1 to A1 or from A1 to R1C1. Something I needed ...

Card image
CopyDynamicRangeValue

Copy values from range to cell. Without using clipboard of course. Here the ...

Card image
Cell_Add_or_Subtract

Adds amount to active cell, or subtract Applies to selected cell in current ...

Card image
AddDatabar_ConditionalFormatting

Adds databars conditional formatting to range of cells. Passing column, start ...

Card image
Range2ANStr

Converts sheet range to ANString, can work on any continued range, 1 or 2 ...

Card image
GetColumnIndex

Returns Id of column (Column Index) from a cell. Similar to GetColumnName, this ...

Card image
CellSave and CellRead

Reads a cell or Saves value into certain cell, in certain sheet and workbook. ...