Search results 149

Sorted from new to old.

Filename_Clean

Returns cleaned file name of invalid characters. Needs to be modified if used ...

2023Jan11

UnixDateTimeNumber

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

2023Jan6

ANStr2Range

Converts a string of items into range, with custom separator. Opposite of

2022Nov11

FoundinList

Finds a matching item of a number in list of numbers. Returns 1 if found, 0 if ...

2022Aug12

Shape_Select_or_CreateThenSelect

Selects a shape inside sheet to change it, or if not found, it will create it ...

2022Jul21

Frm5Textbox

Shows a text in textbox as separate window Caller can modify size of textbox, ...

2022Feb22

CleanFilename

Cleans file name from invalid unexpected characters that Windows refuses.

2022Feb22

CopyFiles

Copies files from list of files into a folder. Uses list of files with ...

2022Feb3

OpenAnyFile

Finally, can have one command to open any file using its default associated app ...

2022Jan28

RowList_Matching

Returns list of rows numbers having cells matching text in a column. Passing ...

2021Dec27

Subtotal_Indirects

Finds the SUM, COUNT, COUNTA, etc for a range of cells referencing using ...

2021Nov26

Special chars

How to type special characters in keyboard using ALT + keypad numbers I also ...

2021Oct13

Frm81 - FullDetails

Show window of details, can be used to show content for certain cell, or show ...

2021Jun26

Frm6 - ANmaMultiSelect

Give users ability to multi-select from list of items into cells with separator. ...

2021Jun23

Morse code functions

Convert text or single character to and from Morse code. TexttoMorse, ...

2021Jun13

CutString8

Cuts a string from certain character to certain character with option of either ...

2021May29

1 2 ...4 ...9 10