Search results 213

Sorted from new to old.

Create Tree from 3 columns (Sheet2Tree)

Converts 3 columns in sheet into 3-generation tree using TreeView from Mscomctl. ...

Aug7

QTexts_Min

Returns minimum quarter of 2 strings representing quarters, like 1Q2024, 3Q2015, ...

Jul27

FilesIn_4Array

Returns list of file names along with path, date modified and size in array of ...

May25

CSS Generators

One of my newest friends in css styling, tons of options. Love the simple ...

May22

ANmaRename2Files

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

Mar16

VBInstr_SpaceFriends_BetweenHTMLTags

Searches for string inside string with multiple possibilities, returns ...

Mar13

VBA/Excel Registry hacks

Set of hacks to modify Excel/VBA settings using Windows registry (Regedit) ...

Mar12

ANmaSafeDeleteFile

Deletes file safely without warnings or error messages. Tries to delete it at ...

Mar10

YoutubeLinks2YoutubeEmbeds

Convert all links in text block into youtube embeds to show inside a website. ...

2024Dec22

FilesIn2 - sorted files

List of files, sorted by name, size or modified date ascending or descending. ...

2024Nov25

ArraySort_3Cols

Returns the Array of 3 cols after sorting it

2024Nov18

ANmaSum_4IFs

Applies SumIFs for 4 columns, same sheet, same workbook Another function to do ...

2024Nov13

Showing 4k (and more) images in BS5 modal

Allow users to browse and scroll through tons of images to select one (tried on ...

2024Nov7

RoundUp2

Rounds a number to nearest identifier up. Like 105 up to nearest 20 ...

2024Oct1

Excel 2408 bug

Serious bug in Office update that was pushed Aug 26th. At least from Excel ...

2024Sep10

Choose2

Returns a value based on an ID. If ID is 1, return 1st value, If ID is 2, ...

2024Aug20

1 2 ...13 14