Search results 31

Sorted from new to old.

MatchIf8

Searches for 8 cells in 8 columns and returns the row number if all found. Has ...

2025May10

ANmaRename2Files

Quick batch file to rename two files. One of my big sources of images for my ...

2025Mar16

ANStrFind_AndOrRemove

Checks (and/or removes) if an item was found in list of items and return 1 if ...

2025Jan12

Unblock blocked macros.

Unblock macros in file copied or downloaded from another machine. Excel keeps ...

2024Jul27

FindLinks xla

Excel Addon to find links in workbook. FindLinks v13.2 From

2024Feb9

CreateThumbSquare_IrfanView

Creates square thumb for an image, regardless of image aspect ratio It will ...

2024Jan18

ANStringListRead_JSON

Reads array into list of ANString, from [ until ] for the giving array name. ...

2024Jan9

SendEmailMsgv2023

Sending email using Microsoft 365 account. Edit 2024-12-19: Fixing ability to ...

2023Nov12

Can't find Project or Library

Fix for Excel VBA error when library not found. Screenshots should show how to ...

2023Sep1

ListPivotsInfo

List All Pivot Tables and their Sources for a given workbook into sheet. ...

2023Aug13

ANStr2Range

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

2022Nov11

RemoveDuplicates

Removes duplicated items from a 1-dim array into new array, does not modify ...

2022Jul7

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

ShowImage

Show an image using irfanview or Windows 7 image viewer. Looking to add more ...

2020Feb16

GeneratePostID

Two functions to generate ID that is unique (not found in database) ...

2019Dec19

1 2