Search results 25

  2. Search results
  3. address
Card image cap
ANmaCellFormat

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

Thu 10AM
Card image cap
SortArea4

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

Apr15
Card image cap
SwitchTextinCells

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

Feb23
Card image cap
ANStrSort3

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

Feb20
Card image cap
Send workbook as email attachment

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

Feb14
Card image cap
RangeValues

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

Jan25
Card image cap
AddressReferenceStyle

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

2023Nov1
Card image cap
CopyDynamicRangeValue

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

2023Aug10
Card image cap
Cell_Add_or_Subtract

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

2022Sep1
Card image cap
AddDatabar_ConditionalFormatting

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

2022Aug22
Card image cap
Range2ANStr

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

2022Jul19
Card image cap
GetColumnIndex

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

2021Nov26