Search results 60

Sorted from new to old.

PrCal_Add_Sort

Adds to daily log, two cells, one with date, next with activity that will be ...

2023Dec2

SQL Date from DateTime

Extract Date from Datetime field in SQL An old method I found in my archive.

2023Nov29

UserChanged_Log4

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

2023Nov28

Between_2Chars

Returns if a char was found between two defined characters. Like find if Loss ...

2023Nov22

BusinessDateDiff

Number of Business days between two dates. Note that it doesn't take Christmas, ...

2023Oct25

FrmRename

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

2023Jul7

ScanFolder

Scans folder and its all subfolders (2 levels only) for files then put file ...

2023Apr7

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

SwapNumbers

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

2022Oct17

RunOnTime

Runs a certain macro on certain time. This is not a scheduler, but just simple ...

2022Sep29

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

SumOf_3Filters

Returns sum of certain column in range (or table) in sheet after applying ...

2021Jan29

UI_2ValidationsUpdate

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

2020May27

1 2 3 4