Search results 60

Sorted from new to old.

SqlExec

Runs SQL Command that needs no return This is primarily useful for CREATE, ...

2023Sep3

IfFullWord

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

2023Jul24

GetAmazonPrice

Reading price of an item in Amazon. An AI-generated function with AI-generated ...

2023Apr3

ANmAdvancedFilter

Filter table inside Excel the fast way (using advanced filter) into another ...

2022Sep15

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

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

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

Save Excel range (or shape) to picture

This is an interesting approach to export a range of cells into picture using ...

2020Dec21

DeleteOtherSheets

Deletes all sheets in a workbook keeping only one

2020Apr3

NextID_Reset

Checks if ID has been reset in SQL database table If yes, it will reset it and ...

2020Mar31

Shortcut website

Create a shortcut to website to open using Internet Explorer in 'InPrivate' ...

2020Jan22

XorD

Encrypt or decrypt a string using a key Similar to XorC, except you get to ...

2020Jan10

1 2 3 4