Search results 174

Sorted from new to old.

WeekNum

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

2018Jun26

EnvVar_All

Read all Environment variables using EnvDir_All Or quickly get user folder, or ...

2018Jun17

MatchIf_ThenDelete

Searches for an item in a column, then if found, delete that cell (not clear, ...

2018Jun17

MatchIf (aka VMatchIf)

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

2018Jun16

ANStrRead + ANStrSave + ANStrSearch

Reads and saves data into 1 dim string array, ANStr ANStr is a string of list ...

2018Jun14

FixPath, IsThere, IsThere1 ...

Set of 6 functions to deal with filesystem. Gets current workbook path, ...

2018Jun11

FileDate_Formatted

Using FileDateTime to get file date

2018Jun10

Multi-line Textbox focus bug

Trick to force textbox with multiple lines and scrollbars to refresh itself ...

2018Jun7

Filter_GotoItem

Allow users to select from list box based on search terms. Have a text box and ...

2018Jun7

RoundUp

Rounds a number up, like Excel function RoundUP

2018Jun2

CutRightString

Cuts a string from a string FROM RIGHT starting from specific character and ...

2018Jun2

CopyText2Clipboard

Copies text to clipboard using MSForms

2018May30

Email-CDONTS

CDONTS with Attachment Example of CDONTSwith attachment for emailing

2018May27

RemoveHTML

Removes HTML code Basically all tags expected and listed below There is a ...

2018May26

GoToInternet

Opens webpage from within Excel, using default browser

2018May22

GetPapa, GetPapa_URL, GetPapa_Sep, GetSon, GetSon_

Gets that parent folder name giving a full path, or gets the child folder, Can ...

2018May22

1 2 ...10 11