BoldCodes

Search results 73

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

2018Aug10

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

2018Aug9

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

2018Jul11

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

2018Jul9

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

2018Jul5

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

2018Jul4

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

2018Jun30

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

2018Jun26

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

2018Jun25

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

2018Jun24

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

2018Jun24

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

2018Jun22