Search results 325

Sorted from new to old.
Card image
FindFile

Finds if a workbook is open or not in same Excel session

Card image
ViewSource

Display content of ASP file (any file for that matters) Using ...

Card image
RGB2HTML + HTML2RGB

Converts RGB color to / from HTML format As bonus, functions RGB_ExtractColor ...

Card image
CreateFullTree

Creates full tree if not found

Card image
WelcomeSheet

A User-Friendly way to ask user to enable macros. Showing an only sheet to let ...

Card image
Error_Raise

To raise a friendly error message with option to show custom error number and ...

Card image
Weighted_Average

Does a weighted average, knowing that mathematical average between two numbers ...

Card image
oShellRun1

Runs a WScript.Shell command with wait until finish and returns 0, 1, 2 or -1 ...

Card image
SortArea5

Sort range or area by 5 columns, range can be any number of columns, but the ...

Card image
FileDateTime

Gets time and date for a file, Date created, accessed or modified. If the file ...

Card image
SortArea3

Sort range or area by 3 columns, range can be any number of columns, but the ...

Card image
SortArea1

Sorts a range or area by 1 column given its cell address, with options to ...

Card image
Sort1Col

Sorts a column in Excel, easily, with options Expects ... Row 1 is header, ...

Card image
Capitalize

This function capitalizes first letter of each of the words in a sentence, ...

Card image
RandomArray

Creates array of random numbers, returns 1 Dim array

Card image
FormulasFlatten

Fill in formulas from 1st row, then convert them to flat values to avoid Excel ...