Search results 73

Sorted from new to old.

VBA/Excel Registry hacks

Set of hacks to modify Excel/VBA settings using Windows registry (Regedit) ...

Mar12

ToggleCells

Toggle a value through list of cells in a range Pass current value and range ...

Feb2

Toggle5Values

Toggles among up to 5 values. Pass the current values, then up to 5 values (in ...

Feb2

VBInstr_Occurance

Returns location of text inside another with jump ability for any certain ...

2024Dec1

SSL/TLS certificate add/update

Always found myself struggling when applying security to websites for the past ...

2024Nov7

Sheet_RowID_Generate + _LastUsed

Generate random unique ID in a column as IDyyyymmRRRR And the second function ...

2024Nov3

HTMLCloseTag_HasWordAfter

Finds the number of occurrence of a "Numeric" inside a string having a certain ...

2024Oct6

FixURL

Return safe URL after converting critical chars to whatever passed in SafeChar

2024Sep16

RegSave, RegRead, RegDelete

Windows Registry read, save and delete branch node or key. Three functions use ...

2024Sep15

CutString96_NumberX

Extract a full number from string block having 1 or more full numbers. Like ...

2024Aug2

Unblock blocked macros.

Unblock macros in file copied or downloaded from another machine. Excel keeps ...

2024Jul27

ANmaReplace_Occurrence

Replaces certain occurrence of a string with another inside a string. Like ...

2024Jul13

Win10 ThisPC Virtual locations

I hate it when Windows forcing us to have additional items in "This PC" So, I ...

2024Feb5

CutString7

Cuts right part of a string starting from certain occurrence of a separator ...

2024Jan1

UserChanged_Log4

Adds date to column1 when user enters text in column2. Also, if user remove ...

2023Nov28

GeWin - get windows list

Gets all windows that are enabled and actived and put them in a list. It also ...

2023Nov10

1 2 3 4 5