Search results 60

Sorted from new to old.
Card image
PivotTable_ShowHideItems

Show or hide item (or items) in PivotTable for a certain field. Passing ...

Card image
MultiRead_JSON

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

Card image
ChartLabelsNumberFormat

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

Card image
ANmaPivotTable_Clear

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

Card image
ChartLegendCenter

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

Card image
ReNumber_IDColumn_inTable

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

Card image
AddDatabar_ConditionalFormatting

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

Card image
ANmaSQL_UpdateDateStatement

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

Card image
CreateUniqueList

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

Card image
Range_SaveAsImage

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

Card image
Row_PixelLocation

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

Card image
Hiding chart in Excel

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

Card image
Save Excel range (or shape) to picture

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

Card image
Graphbar

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

Card image
Custom Excel Right-Click Menus

Customizing Excel's right click menus The following code demonstrates how to ...

Card image
Most recent in Oracle DB

List the most recently added rows based on a date column.