Search results 60

Sorted from new to old.

ConditionalFormatting_Clear

Clears all conditional formatting in a range in a sheet in a workbook.

Nov10

ANmAddress_Dimensions

Detects how many dimensions an address has, This is what I call it dimensions ...

Nov8

ANmAddress_Value

Returns the value of a cell address in another sheet. Todo: Allow to reference ...

Oct31

ProgressPie SVG

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

Feb10

ChartLabelsNumberFormat

Apply Number format of 1 decimal to datalabels of specific series in certain ...

2023Dec23

ANmaPivotTable_Clear

Clears all filters in PivotTable and hide the [blank] item from list, pass ...

2023Dec22

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

SubZero

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

2023May23

Range22DimArray

Imports a range into 2-dimension array. Returns the array, providing range, ...

2023May11

ScrapeURL_ToSheet

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

2023Apr4

ANmAdvancedFilter

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

2022Sep15

Shape_Select_or_CreateThenSelect

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

2022Jul21

Range2ANStr

Converts sheet range to ANString, can work on any continued range, 1 or 2 ...

2022Jul19

ANmaSQL_InsertStatement

Creates SQL INSERT statements from a table in Excel. Used to be executed to ...

2022Jul3

Export2CSV

Exports a sheet into CSV file Dynamically finds number of rows/columns and ...

2022May16

1 2 3 4