Search results 70

Sorted from new to old.

ConditionalFormatting_ColorARow

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

Nov10

ConditionalFormatting_Clear

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

Nov10

Sheet_RowID_Generate + _LastUsed

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

Nov3

ANmaRead_1stFile

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

Aug11

SettingSave + SettingRead for NumberFormat

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

Apr19

ANmaCellFormat

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

Apr18

DateDateDate

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

Mar3

UnUnixDateTime

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

Jan6

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

GeWin - get windows list

Gets all windows that are enabled and actived and put them in a list. It also ...

2023Nov10

USB Format in Car stereo

What format used to let Car stereo read USB thumb drive? To listen to MP3 ...

2023Sep29

USB format in Android

What is the best format to use a USB storage for using in Android phones and ...

2023Sep28

ListPivotsInfo

List All Pivot Tables and their Sources for a given workbook into sheet. ...

2023Aug13

Total14Round

Round time to Hours:Minutes format regardless of number of days Like in 80:40. ...

2023Aug8

Times_inHours

Calculate the total number of hours between two times and return in format ...

2023Jul20

1 2 3 4 5