Search results 14

Sorted from new to old.
Card image
CalculateQuarterText

Returns the text of quarter (3Q2024 or 1Q2017) with offset of the passed ...

Card image
ANmaFilter3

Filter database into new sheet, by copying certain columns only, not whole ...

Card image
Range_Add_or_Subtract

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

Card image
Shape_Select_or_CreateThenSelect

Selects a shape inside sheet to change it, or if not found, it will create it ...

Card image
DateDiff_En

Calculates the differences of date (against NOW) and return in English ...

Card image
Fill down

Fill down series in Excel. NotReadyYet! This is a work-in-progress function! ...

Card image
Save Excel range (or shape) to picture

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

Card image
JSON-VBA

2 modules to read output of json API (or file) into parsed array of objects. ...

Card image
CreateList_Matching

Creates list of items found in rows, where these rows match a value in another ...

Card image
Barcode Generator

Pure ASP Classic barcode generator This is one of my past findings, I will be ...

Card image
FilterSheet_1By1 + FilterSheet_Clear

Sets Autofilter in a sheet, and another function to clear Autofilter ...

Card image
Control the Panel

A set of commands (or shortcuts) allowing users to access Control panel items ...

Card image
OnChange

Detect when user changes a textbox using JQuery Needed to have this documented ...

Card image
Upload5

Uploading files into server, the simplest way I have here This is the famous ...