Search results 107

Sorted from new to old.

Styles_DeleteNonStandard

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

2018Aug12

CopyFormat

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

2018Aug10

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

ConvertMultiLine2 + 6

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

2018Jul11

SplitTo2DArray

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

2018Jul9

SortArea5

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

2018Jul5

SortArea3

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

2018Jul4

SortArea1

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

2018Jul4

CellSave (SimpleSave)

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

2018Jun26

CellRead (SimpleLookup)

Simply reading a value from a specific cell from a sheet from a workbook ...

2018Jun25

CellHyperlink_ToSheet

Will add hyperlink in a cell to a sheet in same workbook Not Hyperlink ...

2018Jun24

LogSheet_Add + LogSheet_Clear

2 Functions LogSheet_Add and LogSheet_Clear to add new entry to log or clear ...

2018Jun24

RowsCount

Get total number of rows for a certain worksheet in certain workbook workbook ...

2018Jun22

CellCommentRead + Save

Reads/Saves a comment into a cell CellCommentRead to Reads comment from a ...

2018Jun17

MatchIf_ThenDelete

Searches for an item in a column, then if found, delete that cell (not clear, ...

2018Jun17

1 2 ...6 7