Search results 83

Sorted from new to old.

CountDuplicates

Counts how many duplicates found in a range of Excel cells. Basically how many ...

2020Oct31

Part of cells in Excel

How to modify part of text inside an Excel cell using VBA. Something in my ...

2020Oct13

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

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

1 2 ...4 5 6