Search results 16

Sorted from new to old.

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

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

AddressReferenceStyle

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

2023Nov1

Cell_Add_or_Subtract

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

2022Sep1

Tabindex in multipage

Tabindex and forcing focus to show in textbox if we have multipage control. ...

2021Dec6

GetColumnIndex

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

2021Nov26

CellSave and CellRead

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

2020Oct31

Unprotect sheet or workbook

Unprotect worksheet (and workbook) using VBA code

2019Apr25

ApplyValidation_DropDown

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

2018Aug10

CellSave_Hyperlink

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

2018Aug9

getDaysInMonth

Gets number of days in a certain month

2018Jul15

SortArea3

Sort range or area by 3 columns, range can be any number of columns, but the ...

2018Jul4

CellSave (SimpleSave)

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

2018Jun26

GetColumnName, ColumnName_XOffset

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

2018Jun15