Search results 60

Sorted from new to old.

MultiRead_JSON

Reads array of arrays from the parent and return back ANString of 3 columns

2024Jan13

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

ChartLegendCenter

Put chart legend at center of chart horizontally. Changes left and width only. ...

2023Dec21

ReNumber_IDColumn_inTable

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

2023Dec17

Latest records date and count

Find how many items in table, with column DateAdded is the latest DateAdded in ...

2023Nov2

ANmaFilter3

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

2023Oct13

AddDatabar_ConditionalFormatting

Adds databars conditional formatting to range of cells. Passing column, start ...

2022Aug22

ANmaSQL_UpdateDateStatement

Creates "Update Table " SQL statements to be executed inside SQL to modify ...

2022Jul4

CreateUniqueList

Create list of unique items from a column into another column This is similar ...

2022Apr26

Range_SaveAsImage

Exports range to an image, something we wanted to be able to do for a while now. ...

2022Feb16

Row_PixelLocation

Gets the cell row where a certain shape is located by passing shape.Top number ...

2021Feb2

Hiding chart in Excel

How to hide a full chart in Excel. By treating it as shape, not as chart.

2020Dec31

Save Excel range (or shape) to picture

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

2020Dec21

ConcaUFO_RowsfromSheets

Imports rows from multiple sheets of a workbook into final sheet along with ...

2020Nov11

Graphbar

Interactive graph bars, will go deeper when you click on the bar Originally ...

2020Aug16

1 2 3 4