MyDev

Search results 9

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

Apr18

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

2023Nov1

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

2022Sep1

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

2021Nov26

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

2020Oct31

Adds Validation drop-down to a cell (Data --> Validation --> List), or to a ...

2018Aug10

Creates a hyperlink to URL or to cell inside a cell in Excel VBA (or delete it). ...

2018Aug9

Saves value to cell without deformation and converting Used to be called ...

2018Jun26

Gets the column name from a cell address. Returns "E" from "E45", or "BR" from ...

2018Jun15