Search results 128

Sorted from new to old.

VBInstr_Occurance

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

2024Dec1

CutString96_NumberBefore and After

Cuts the number found before our search word by going back certain number of ...

2024Nov24

VBInstr_Any

Search for string inside another, with ability to have multiple strings to ...

2024Nov15

ANmaSum_4IFs

Applies SumIFs for 4 columns, same sheet, same workbook Another function to do ...

2024Nov13

ANmAddress_Value

Returns the value of a cell address in another sheet. Todo: Allow to reference ...

2024Oct31

QuickEncrypt plus others ...

Text encryption/decryption snippet that utilizes the powerful xICE encryption ...

2024Aug15

DownloadFile_Safe

Downloading file directly to machine without refreshing or going to another ...

2024Jul27

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

MatchIF5

Searching for rows having 5 values in 5 columns Like

2024May6

CopyFields_FromTo

Moves strings within cells into other cells, move or copy. Specific task to ...

2024Apr17

CopyFiles Excel-Macro

Simple macro to make sure we have a copy of all files in a folder found in ...

2024Mar12

OneDrive Reset

Reset OneDrive because I am a heavy OneDrive user. Most recent instructions, ...

2024Mar5

DateDateDate

Finds three dates after each other in one paragraph. Needed to locate numbers ...

2024Mar3

NumberNumberNumber

Finds 3 numbers in a string by ignoring characters between them. ' example ...

2024Mar2

SwitchTextinCells

Switch text inside cells with another text. This was needed to correct an bug ...

2024Feb23

1 2 ...7 8