Search results 54

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

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

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

DB Functions (By AI)

3 functions to add or update data to DB and Read from DB. These were also ...

2023Apr23

ScrapeURL_ToSheet

Reads content of Page from URL to a sheet. This was made specially for certain ...

2023Apr4

NavigatePost

Reads content of webpage with optional post data two main differences from

2023Jan14

ANmAdvancedFilter

Filter table inside Excel the fast way (using advanced filter) into another ...

2022Sep15

1 2 3 4