Search results 61

Sorted from new to old.

ANStrColor2RGBA_Para

Returns Red, Green, Blue and Transparency from text representing color Like ...

2025Dec20

ShapeCreate_SomeVariables

Create a shape in certain sheet with options Some other options are hard-coded, ...

2025Sep30

Outlook data files

Custom default location for Outlook data files. Tell Outlook to always store ...

2025Jun18

ANmaSum_4IFs

Applies SumIFs for 4 columns, same sheet, same workbook Another function to do ...

2024Nov13

Quarter1stLastDate_FromQuarterText

Returns the date of 1st day or last day in a Quarter Mar 31st, Jun 30th, Sep ...

2024Jul26

QuarterNumber_FromDate

Returns the number of quarter from a date

2024Jul26

Q_NoOfdays

Calculates number of days for certain quarter, starting from given quarter with ...

2024Jun9

FindLinks xla

Excel Addon to find links in workbook. FindLinks v13.2 From

2024Feb9

SQL Cross Apply String_Split with XML Path

SQL select statement to convert list of IDs found in column (from more than row ...

2024Jan20

HTMLPaddingMargin_v2

Finds the padding or margin from a style statement for an HTML tag. Passing ...

2024Jan5

FontAwesome Custom icons issue

I faced an issue the past few weeks when trying to add my own icon to ...

2023Dec29

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

SQL Date from DateTime

Extract Date from Datetime field in SQL An old method I found in my archive.

2023Nov29

SearchinHTMLTable

Search for a word in a certain column in html table and return the full row ...

2023Nov12

1 2 3 4