Search results 57

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

Outlook data files

Custom default location for Outlook data files. Tell Outlook to always store ...

Jun18

ANStrVLookup

behaves as vlookup to return item from 2-dim ANStr Can choose which column, ...

Jun14

ANmaDropdown Search

Shows drop down menu of matching items when user searches in textbox with ...

May13

UsedRange

Returns the address of first:Last cells with data in sheet. Like pressing ...

May12

1st cell of sheet range

Returns the address of first cell in data in range, the very first cell of very ...

May12

HTMLTableRow_LastRowWithData

Retunes the row from bottom that has data (not blank or hidden)

Feb19

CountRowCells

Counts how many cells with data in a row, starting from certain column until ...

2024Jun22

CutString97

Cuts part from large string from certain character to certain character with ...

2024Jun5

CopyFields_FromTo

Moves strings within cells into other cells, move or copy. Specific task to ...

2024Apr17

Concatenate_HTMLColumn

Build a string from a certain column in html table (using < table, < tr, and < ...

2024Mar14

ProgressPie SVG

jQuery library to create ProgressPie SVGs. Simple, perfect, works

2024Feb10

ReNumber_IDColumn_inTable

Reset numbers in ID column, with help from AI. The StoredProcedure will move ...

2023Dec17

ANmaFilter3

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

2023Oct13

Column1Range

Return range of cells in column having data where, ignoring header cell and ...

2023Oct7

SubZero

Forces Excel to not convert numbers during moving them across sheets, or ...

2023May23

1 2 3 4