Search results 61

Sorted from new to old.

Antispam - Hiding textbox

Anti spam email web form idea.

2022Nov14

ANStr2Range

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

2022Nov11

HyperlinkFunction

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

2022Aug24

AddDatabar_ConditionalFormatting

Adds databars conditional formatting to range of cells. Passing column, start ...

2022Aug22

LastRow_Remove

Removes last row in a table starting certain cell. Creating and using this ...

2022Aug16

ANmaSQL_UpdateDateStatement

Creates "Update Table " SQL statements to be executed inside SQL to modify ...

2022Jul4

IsError_Range

Checks if range has at least one error in a range of cells Fast, and simple

2021Dec30

Subtotal_Indirects

Finds the SUM, COUNT, COUNTA, etc for a range of cells referencing using ...

2021Nov26

Highlight row of current month

Highlight row in Excel if it is within current month This is another version ...

2021Sep2

Morse code functions

Convert text or single character to and from Morse code. TexttoMorse, ...

2021Jun13

Logging use of executable in Windows

Log the use of .exe, .lnk, .pif, .bat, and .com files on your computer. All it ...

2021Jun13

Excel crashes when File > Print

During generating Print Preview, Excel crashes. Applies to some files, not all, ...

2021Mar6

2 VB.net pdf books

Free from apress website https://www.apress.com More books

2021Mar2

Resize_Me2 + Resize_Me3

Resizes Excel window to certain small size and location (hard-coded) and hide ...

2020Dec11

TrimEnters

SQL Function to remove repeated Enters from a string in SQL Chr(13) + Chr(10)

2020Sep19

SortedFiles

Get a sorted list of files in a directory using the File System Object (FSO) ...

2020Aug11

1 2 3 4