Search results 77

Sorted from new to old.

QTexts_Min

Returns minimum quarter of 2 strings representing quarters, like 1Q2024, 3Q2015, ...

Jul27

Calculation_StaleValues

Show Stale function formats or hide Excel recently started to show cells with ...

Jun30

ANmAraDate

Format full date in Arabic language using several known Arabic month syntax. ...

Jun12

Add bulk rows to DB Table

Inserts multiple rows into DB table as whole Unlike

May27

ImageMSO list

List of all images in ImageMSO used in ribbon as well in other parts of VBA in ...

Apr30

ANmaRow_Duplicate1

Duplicate 1 row into row below with insert using fill down or copy-paste No ...

Apr17

ConditionalFormatting_ColorARow

Adds conditional formatting to color a row in table based on output of formula ...

2024Nov10

ConditionalFormatting_Clear

Clears all conditional formatting in a range in a sheet in a workbook.

2024Nov10

Sheet_RowID_Generate + _LastUsed

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

2024Nov3

ANmaRead_1stFile

Returns information about first file name found after sorting matching files in ...

2024Aug11

SettingSave + SettingRead for NumberFormat

Reads or applies certain NumberFormat to cell in settings. Same patterns as ...

2024Apr19

ANmaCellFormat

Reads or set Numberformatting for a cell or range. Can pass sheet and workbook ...

2024Apr18

DateDateDate

Finds three dates after each other in one paragraph. Needed to locate numbers ...

2024Mar3

UnUnixDateTime

Convert a number represents a date in Unix format back into date, opposite of ...

2024Jan6

ChartLabelsNumberFormat

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

2023Dec23

MathInsideANString

Perform math on numbers inside list of numbers in format of ANString. ...

2023Nov20

1 2 3 4 5