Search results 45

Sorted from new to old.

Unprotect worksheet (and workbook) using VBA code

2019Apr25

Generate random GUID of 36 chars (with or without brackets) using TypeLib ...

2018Jun25

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

2018Jun24

Converts color into its negative value, as in "e4f15a" into "1C0FA6"

2018Jun20

Read directories in a specified folder into a combobox Needs FrmBr having Cbo1

2018Jun18

Checks if one char is within two ASCII codes or not (StringASCIIs) Used to see ...

2018Jun17

Detects active desktop screen resolution and location of taskbar (with some ...

2018Jun17

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

2018Jun17

Matching 4 values at the same time in 4 columns Just like Match the function, ...

2018Jun16

Matching three values at the same time in three columns Just like Match the ...

2018Jun16

Matching by two values at the same time in two columns Just like Match the ...

2018Jun16

Horizontal match for a value in a row Horizontal MatchIf, returns column ...

2018Jun16

The best Match I created, return 0 if not found, kind of CountIF+Match ...

2018Jun16