Search results 142

Sorted from new to old.

IfFoundInList

Checks to see if sStr matches on of the items in Listof, knowing separator, ...

2023Jul24

IfFullWord

Returns True if found as full, False if not found as full Full word means word ...

2023Jul24

FrmRename

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

2023Jul7

Range2Block

Concatenate all rows found in a range starting A1Cell for Columns_To columns ...

2023Mar6

Range_Add_or_Subtract

Adds an amount (or subtract) from a range of cells in one click Similar to

2023Feb18

ANStr2Range

Converts a string of items into range, with custom separator. Opposite of

2022Nov11

ANmaRemoveDuplicates

Removes duplication in table in 1 or more columns using Excel ...

2022Sep25

HyperlinkFunction

Returns the formula for a hyperlink [=Hyperlink(...) ] to be inserted in a cell. ...

2022Aug24

DiskDriveType

Returns drive type as text, like fixed, CD, etc. Can pass either drive letter, ...

2022Aug17

FoundinList

Finds a matching item of a number in list of numbers. Returns 1 if found, 0 if ...

2022Aug12

Range2ANStr

Converts sheet range to ANString, can work on any continued range, 1 or 2 ...

2022Jul19

GetHeaders

Reads page headers into dictionary object. an example of using Dictionary in ...

2022May5

DBTables

Returns an array of all table names in a database. needs valid OLE database ...

2022Apr28

Frm5Textbox

Shows a text in textbox as separate window Caller can modify size of textbox, ...

2022Feb22

SaveAsHTML_Template

Creates HTML file using template found in a column. Have lines of HTML in a ...

2022Feb5

CopyFiles

Copies files from list of files into a folder. Uses list of files with ...

2022Feb3

1 2 ...5 ...8 9