Search results 31

Sorted from new to old.

UsedRange

Returns the address of first:Last cells with data in sheet. Like pressing ...

Mon 1PM

1st cell of sheet range

Returns the address of first cell in data in range, the very first cell of very ...

Mon 1PM

ToggleCells

Toggle a value through list of cells in a range Pass current value and range ...

Feb2

ANmAddress_Dimensions

Detects how many dimensions an address has, This is what I call it dimensions ...

2024Nov8

ANmAddress_Value

Returns the value of a cell address in another sheet. Todo: Allow to reference ...

2024Oct31

ANmAddressSame

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

2024Sep24

ANmAddressRefStyle

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

2024Sep23

ANmaCellChar_Superscript_Subscript

Sets certain character inside a cell as superscript or subscript Edit ...

2024Aug11

ANmaCellFormat

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

2024Apr18

SortArea4

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

2024Apr15

SwitchTextinCells

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

2024Feb23

ANStrSort3

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

2024Feb20

Send workbook as email attachment

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

2024Feb14

RangeValues

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

2024Jan25

AddressReferenceStyle

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

2023Nov1

CopyDynamicRangeValue

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

2023Aug10

1 2