Search results 60

Sorted from new to old.
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
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
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.

Card image
CSS Charts

Great articel about making charts in CSS. It has 3 main types, bar, column, ...

Card image
FilterSheet_1By1 + FilterSheet_Clear

Sets Autofilter in a sheet, and another function to clear Autofilter ...

Card image
all_tab_columns

List all columns in all tables for all schemas in oracle db workbench