Search results 75

Sorted from new to old.

UsedRange

Returns the address of first:Last cells with data in sheet. Like pressing ...

Mon 1PM

1st cell of sheet range

Returns the address of first cell in data in range, the very first cell of very ...

Mon 1PM

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

1 2 3 4 5