Search results 14

Card image cap
CalculateQuarterText

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

Card image cap
ANmaFilter3

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

Card image cap
Range_Add_or_Subtract

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

Card image cap
Shape_Select_or_CreateThenSelect

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

Card image cap
DateDiff_En

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

Card image cap
Fill down

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

Card image cap
Save Excel range (or shape) to picture

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

Card image cap
JSON-VBA

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

JSON-VBA.zip

Card image cap
CreateList_Matching

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

Card image cap
Barcode Generator

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

Barcode.zip

Card image cap
FilterSheet_1By1 + FilterSheet_Clear

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

Card image cap
Control the Panel

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