Search results 252

Sorted from new to old.

SortArea3

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

2018Jul4

SortArea1

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

2018Jul4

Sort1Col

Sorts a column in Excel, easily, with options

2018Jul4

Capitalize

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

2018Jul3

XorC

Simple small function to Encrypt or Decrypt a string Test_XorC is for testing ...

2018Jul1

WordsOf + Words_Len

WordsOf to create list of words from a block after converting every special ...

2018Jun28

TextPercentageMatch

Matching any part of a string in another , then returns 0 if not match, Or ...

2018Jun26

WeekNum

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

2018Jun26

Ordinal

Get a Number Suffix They allow you to turn 1 into 1st, 2 into 2nd, etc. giving ...

2018Jun24

File_FirstFound

Gets first file found matches a wildcards mask, using Dir()

2018Jun20

Hex2Dec

Converts hexadecimal strings into decimals

2018Jun20

Dec2Hex

Converts integer decimals into Hexadecimals

2018Jun20

BinaryFile_Read + BinaryFile_Save

Reads binary file in chunks, if not chuck defined, all file will be red/saved ...

2018Jun18

HardDrivePartitionSN

Get Hard drive SN (old fashioned way) using FileSystemObject

2018Jun15

Convert2SQLDate

Converts a date (numeric date) into Date acceptable by SQL, as in YYYY-MM-DD ...

2018Jun14

BrowseFolder

Asks user for a folder tested in VBA of word as well as VBA in Excel

2018Jun14

1 2 ...15 16