Search results 242

Sorted from new to old.

ANmaFormatLastRow

Format last row found/added in Excel range to certain color. ColorText is the ...

Mar26

FormatNumbers_InsideText

Formats all numbers found inside text to certain format. Excluding numbers ...

Mar9

Textbox_PartialBold

Set part of textbox to bold, starting from StartingChar (like : ) that found in ...

2025Nov13

Create Tree from 3 columns (Sheet2Tree)

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

2025Aug7

QTexts_Min

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

2025Jul27

Calculation_StaleValues

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

2025Jun30

punycode

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

2025Jun8

ANmaCountChars_Direction

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

2025May24

Custom Excel UI ribbon

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

2025May11

MatchIf8

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

2025May10

MatchIf8Up

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

2025May7

ANmaUploadFTP_FilesFrom2Columns

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

2025May4

MatchIf7Up

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

2025May3

MatchIf7

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

2025May2

ANmaUploadFTP_FilesListto1Folder

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

2025May1

ImageMSO list

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

2025Apr30

1 2 ...15 16