Search results 239

Sorted from new to old.

Create Tree from 3 columns (Sheet2Tree)

Converts 3 columns in sheet into 3-generation tree using TreeView from Mscomctl. ...

Aug7

QTexts_Min

Returns minimum quarter of 2 strings representing quarters, like 1Q2024, 3Q2015, ...

Jul27

Calculation_StaleValues

Show Stale function formats or hide Excel recently started to show cells with ...

Jun30

punycode

Encode or Decode Punycode used in domain names that are not in English ASCII ...

Jun8

ANmaCountChars_Direction

Counts how many times we found OfChar repeated in TheStr from one of two ...

May24

Custom Excel UI ribbon

Excel custom ribbon in details. A good article I use as reference to add custom ...

May11

MatchIf8

Searches for 8 cells in 8 columns and returns the row number if all found. Has ...

May10

MatchIf8Up

Searches for 8 cells in 8 columns and return the row number if all found Just ...

May7

ANmaUploadFTP_FilesFrom2Columns

Upload files in column each to folder in next column. Expects to have two ...

May4

MatchIf7Up

Returns row number having 7 values in 7 columns if all found. With option of < ...

May3

MatchIf7

Finds the row of 7 columns matching 7 values with options of < > <> and <= ...

May2

ANmaUploadFTP_FilesListto1Folder

Creates script to upload list of files found in column. Will upload all files ...

May1

ImageMSO list

List of all images in ImageMSO used in ribbon as well in other parts of VBA in ...

Apr30

MatchIf4Up

Returns row of matching 4 values in 4 columns searching from bottom to top. ...

Apr12

VBInstr_Rev_Any

Finds first match of string inside another in reverse order. From right to left ...

Apr11

DateAdd_Networkdays

Adds workdays to a date using DateAdd It keeps adding days and checks how many ...

Apr6

1 2 ...14 15