Search results 77

Sorted from new to old.

HTML_CountTags

Counts how many certain tag found in an HTML block. like how many tr found in ...

Fri 5PM

ANmaRemoveBlanks_1Col

Remove blank cells from 1 column

2024Nov17

ANmAddress_Dimensions

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

2024Nov8

Sheet_RowID_Generate + _LastUsed

Generate random unique ID in a column as IDyyyymmRRRR And the second function ...

2024Nov3

Center Userform

Looks like forcing a Userform to be in center of an application is not as easy ...

2024Jul23

ANmAdd_ThenSort_2Columns

Adds values of 2 cells into 2 columns (usually below them). I used these small ...

2024Jun1

PivotTable_ShowHideItems

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

2024Jan23

PivotTable_ShowHideBlankItems

Shows or hides an item or items in a PivotTable filter field. Passing ...

2024Jan22

SettingRead_Ajax + SettingRead_Ajax_IntoObject

Two functions to return an output of file into object on page or back to caller ...

2024Jan12

Grandchildren files and count

Returns list of files in 2 level folders Will not find files as children of ...

2024Jan11

ANStringListRead_JSON

Reads array into list of ANString, from [ until ] for the giving array name. ...

2024Jan9

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

ContainerHTMLTag_Index

Returns location of the tag that enclosing the location provided inside HTML ...

2023Oct22

ContainerHTMLTag

Returns HTML tag of the container of certain location inside HTML block. ...

2023Oct21

1 2 3 4 5