Search results 80

Sorted from new to old.

FrmRename

Userform to switch names of two files. Basically renaming two files with each ...

2023Jul7

Autofit height iframe

iframe with animated gif to show while loading content, when iframe is fully ...

2023May25

Progress in two nested loops

Formula to show progress to end user from inside two loops. More like an ...

2023Mar7

NavigatePost

Reads content of webpage with optional post data two main differences from

2023Jan14

UnixDateTimeNumber

Calculates Unix date/time number of a given date/time. Needed it to pass ...

2023Jan6

OutlookFolder_DuplicatesRemove

Removes duplicated emails in an outlook folder. Originally not my work, ...

2023Jan1

SwapNumbers

Swap two numbers variables without using third variable A trick worth saving ...

2022Oct17

DateDiff_En

Calculates the differences of date (against NOW) and return in English ...

2022Mar3

NMRRank_v2021

Ranks a number among set of numbers. This is part of huge tool, we needed to ...

2021Sep23

CleanArray

Cleans array of unwanted items This usually needed after you merge two arrays, ...

2021Sep22

merge2Arrays

Merges two 1-dimension arrays and return an array Both should be 1 dimensional ...

2021Sep21

ExitTool and DoNothing

My way of Exiting tool in case or error, also another sub that basically does ...

2020Oct31

Nautical/Flight Functions

Functions perform various calculations useful for planning trips. MPH2Kt: ...

2020Oct13

UI_2ValidationsUpdate

Apply validation on two cells, when a 3rd cell is changed When modifying a ...

2020May27

Remove_Between2Quotes

Remove any char (or string) found between two quotes in a string This is an ...

2020Mar9

Decode and NVL

Two oracle SQL functions, that are interesting. Decode to work as (Select ...

2020Feb7

1 2 3 4 5