Search results 52

  2. Search results
  3. 14 days
Sorted from new to old.
Card image
ANStrColor2RGBA_Para

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

2025Dec20
Card image
Formulas_FromRow_toFile

Exports all formulas in a row of sheet into text file.

2025Oct10
Card image
MatchIf8

Searches for 8 cells in 8 columns and returns the row number if all found. Has ...

2025May10
Card image
ANString_to_ListSelects

Selects items in listbox from ANStringList. Assuming listbox is multi-select ...

2025Mar24
Card image
ListBox_Read and ListBox_Save

Reads or saves to a certain column in multi-column listbox in VBA Userform Can ...

2025Mar11
Card image
CountColumnCells_Unique

COunts unique cells found in a column. Passing sheetname, workbook name and ...

2024Oct6
Card image
Daily folder

Create daily folder in specific location automatically. I used to have .bat ...

2024Jul28
Card image
Quarter1stLastDate_FromQuarterText

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

2024Jul26
Card image
DateDiff_Networkdays

Calculates no of workdays between two dates. Option to use international ...

2024Jul25
Card image
CalculateQuarterText

Returns the text of quarter (3Q2024 or 1Q2017) with offset of the passed ...

2024Jun10
Card image
Q_NoOfdays

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

2024Jun9
Card image
ContainerHTMLTag_ReturnBlock

Returns the full string starting from open tag of container where LocationIndex ...

2024Apr3
Card image
SQL instr

Searching for a string inside a string in SQL. You may say it is the instr in ...

2024Feb3
Card image
HTMLTagID_Previous

Return id for any html tag that was found above certain location of html page. ...

2024Feb2
Card image
PrCal_Add_Sort

Adds to daily log, two cells, one with date, next with activity that will be ...

2023Dec2
Card image
SQL Date from DateTime

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

2023Nov29
1234