Search results 628

Sorted from new to old.

DownloadFile_Safe

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

Jul27

Unblock blocked macros.

Unblock macros in file copied or downloaded from another machine. Excel keeps ...

Jul27

DateDiff_Networkdays

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

Jul25

Center Userform

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

Jul23

ANStr_RemoveDuplicates

Removes duplication in ANStr separated by a separator.

Jul13

ReturnLongestString_Of2

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

Jul2

CalculateQuarterText

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

Jun10

ANmAdd_ThenSort_2Columns

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

Jun1

MatchIf6

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

May31

Microsoft Edge gestures

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

May27

CountColumnCells_2Criteria

Counts how many cells matching 2 criterias. Just like

May1

ANString_Location

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

Apr23

SettingSave + SettingRead for NumberFormat

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

Apr19

CopyFields_FromTo

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

Apr17

ListBox bug with TabIndex

Setting TabIndex for a listbox to 0 in a Userform will have some issues when ...

Apr15

SortArea4

Sort range of cells by up to 4 columns. Can use any of these columns, not ...

Apr15

1 2 3 ...39 40