Search results 61

Sorted from new to old.
Card image
ANStrColor2RGBA_Para

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

Card image
ShapeCreate_SomeVariables

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

Card image
Outlook data files

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

Card image
ANmaSum_4IFs

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

Card image
Quarter1stLastDate_FromQuarterText

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

Card image
QuarterNumber_FromDate

Returns the number of quarter from a date

Card image
Q_NoOfdays

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

Card image
FindLinks xla

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

Card image
SQL Cross Apply String_Split with XML Path

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

Card image
HTMLPaddingMargin_v2

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

Card image
FontAwesome Custom icons issue

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

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
SQL Date from DateTime

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

Card image
SearchinHTMLTable

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