ReplaceStrings

Replace strings found in list of strings from inside a string, does taht make ...

Subdomain to a folder

Redirects a subdomain into a folder child of main domain, named same as ...

ANmaFilter3

Filter database into new sheet, by copying certain columns only, not whole ...

BusinessDateAdd

Counts the number of business days Add or subtract a number of business days ...

SheetTabColor

Applies certain color to sheet tab in Excel. ColorNumber is Excel ColorIndex. ...

FilesIn_Array and FoldersIn_Array

Return list of files in a folder back as array. Similar to

ListPivotsInfo

List All Pivot Tables and their Sources for a given workbook into sheet. ...

CopyDynamicRangeValue

Copy values from range to cell. Without using clipboard of course. Here the ...

List_of_Names + DeleteNames

List names in a certain workbook into sheet. And Deletes those names. You may ...

FrmRename

Userform to switch names of two files. Basically renaming two files with each ...

frmRename.zip

Excel user name

Get application user name or change it Originally from

SubZero

Forces Excel to not convert numbers during moving them across sheets, or ...