Search results 663

Sorted from new to old.

FindZipFile_WShell

Finds the first zip in a folder matching wild cards mask using WScript.Shell ...

2024Aug2

FindImg_WShell

Finds the first image in a folder matching wild cards mask using WScript.Shell ...

2024Jul31

Daily folder

Create daily folder in specific location automatically. I used to have .bat ...

2024Jul28

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

DateDiff_Networkdays

Calculates no of workdays between two dates. Option to use international ...

2024Jul25

Center Userform

Looks like forcing a Userform to be in center of an application is not as easy ...

2024Jul23

ANStr_RemoveDuplicates

Removes duplication in ANStr separated by a separator.

2024Jul13

ReturnLongestString_Of2

Returns the string that is longer, comparing what is before StrSepa versus ...

2024Jul2

CalculateQuarterText

Returns the text of quarter (3Q2024 or 1Q2017) with offset of the passed ...

2024Jun10

ANmAdd_ThenSort_2Columns

Adds values of 2 cells into 2 columns (usually below them). I used these small ...

2024Jun1

MatchIf6

Searching for row have 6 matches found in 6 different columns, because we had 5, ...

2024May31

Microsoft Edge gestures

Microsoft Edge Right-mouse gestures I found that will really save me time ...

2024May27

CountColumnCells_2Criteria

Counts how many cells matching 2 criterias. Just like

2024May1

ANString_Location

Finds the location of a sting inside list of strings with certain separator, or ...

2024Apr23

SettingSave + SettingRead for NumberFormat

Reads or applies certain NumberFormat to cell in settings. Same patterns as ...

2024Apr19

1 2 ...5 ...41 42