Search results 143

Sorted from new to old.

ANmaDate

Returns date in human format. Which is as follows... Just day name (and time) ...

2023Apr27

ReadLastChars

Reads last some characters of a file, needs to see contents of large files that ...

2023Apr20

AskForFolder

Asks user to assign a folder, been looking for something like this for awhile ...

2023Mar23

Progress in two nested loops

Formula to show progress to end user from inside two loops. More like an ...

2023Mar7

Filename_Clean

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

2023Jan11

MultiTrim

Trims leading and trailing tabs, spaces and Enters Code has lines to work in ...

2022Dec3

Dropdown button commands

A drop-down of multiple commands in pure VBA. Needed this in a large Excel-VBA ...

2022Oct12

LstCustomSelection_Refresh

Read list of items from Settings sheet, then Sort, then save, before reading ...

2022Aug31

DiskDriveType

Returns drive type as text, like fixed, CD, etc. Can pass either drive letter, ...

2022Aug17

OST Outlook file location

Outlook OST (and PST) files to be saved in different location Instruction can ...

2022May12

DynamicFill

Fills in more rows at end of a range Used to add more rows at end to have all ...

2022Mar11

DateDiff_En

Calculates the differences of date (against NOW) and return in English ...

2022Mar3

COUNTIFS as Rank

Simplest way to rank among peers. used COUNTIFS in case we need to add more ...

2022Jan1

A is for Alpha

Military way to communicate letters in audio, for me I learned not all required, ...

2021Dec6

Tabindex in multipage

Tabindex and forcing focus to show in textbox if we have multipage control. ...

2021Dec6

CleanArray

Cleans array of unwanted items This usually needed after you merge two arrays, ...

2021Sep22

1 2 ...5 ...8 9