Search results 92

Sorted from new to old.
Card image
List_Load + List_Save

Loads/Saves items from/to text file to/from listbox Also has simple adding and ...

Card image
FindFile

Finds if a workbook is open or not in same Excel session

Card image
WelcomeSheet

A User-Friendly way to ask user to enable macros. Showing an only sheet to let ...

Card image
DuplicateFileName

Generates new available file name for a certain file in order to duplicate it, ...

Card image
Limit Textarea

Show number of characters in a textarea and limit if it goes greater than ...

Card image
WordsOf + Words_Len

WordsOf to create list of words from a block after converting every special ...

Card image
WeekNum

Generates the calendar week number for a certain date, counting the first week ...

Card image
SettingRead_JR

Reads setting saved in columns J:R Just like SettingRead, but when we have ...

Card image
LogSheet_Add + LogSheet_Clear

2 Functions LogSheet_Add and LogSheet_Clear to add new entry to log or clear ...

Card image
RowsCount

Get total number of rows for a certain worksheet in certain workbook workbook ...

Card image
Match4

Matching 4 values at the same time in 4 columns Just like Match the function, ...

Card image
Match3

Matching three values at the same time in three columns Just like Match the ...

Card image
Match2

Matching by two values at the same time in two columns Just like Match the ...

Card image
HMatchIf

Horizontal match for a value in a row Horizontal MatchIf, returns column ...

Card image
MatchIf (aka VMatchIf)

The best Match I created, return 0 if not found, kind of CountIF+Match ...

Card image
ListBox_SelectedIndexes

Create list of selected items in MSForms listbox as string separated by | Or ...