Search results 96

Sorted from new to old.

UI_2ValidationsUpdate

Apply validation on two cells, when a 3rd cell is changed When modifying a ...

2020May27

FilterSheet_1By1 + FilterSheet_Clear

Sets Autofilter in a sheet, and another function to clear Autofilter ...

2020Jan3

Add2Column

Quickly adds value to certain column in Excel sheet As usual, you can define ...

2020Jan3

Copy formulas

How to copy formulas in VBA code. Learned that the hard way, just like most of ...

2019Oct3

CopyRowHeight

Copy row height from row to another Used to fix row heights or merged cells to ...

2019Aug1

DirTree.xlsb

Excel macro to show all files found in directory (including sub-directories) as ...

2019May20

UnMergeFill

Unmerges all merged cells and duplicate cell contents into them. In another ...

2019Apr16

User-Defined Formatting

Apply special Conditional Formatting, color cells based on their values. This ...

2019Jan9

ChrW

Insert special characters inside Cell, using ChrW

2018Sep19

CopyRange_NoClipboard

Copies range without using clipboard. Applies formats into a cell (or range) ...

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

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

1 2 ...5 6