Search results 90

Card image cap
ChrW

Insert special characters inside Cell, using ChrW

Card image cap
Styles_DeleteNonStandard

Delete styles from an Excel workbook, any non-standard style will be deleted. ...

Card image cap
CopyFormat

Applies format into a cell (or range) from another cell. Can apply from any ...

Card image cap
ApplyValidation_DropDown

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

Card image cap
CellSave_Hyperlink

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

Card image cap
ConvertMultiLine2 + 6

Convert text blocks (by converting line separators from any separator to any). ...

Card image cap
SplitTo2DArray

Splits ANStrArray into 2-Dimension array Using custom row and column ...

Card image cap
SortArea5

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

Card image cap
SortArea3

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

Card image cap
SortArea1

Sorts a range or area by 1 column given its cell address, with options to ...

Card image cap
XorC

Simple small function to Encrypt or Decrypt a string in cell Test_XorC is for ...

Card image cap
FormulasFlatten

Fill in formulas from 1st row, then convert them to flat values to avoid Excel ...