Search results 256

  2. Search results
  3. name
Sorted from new to old.
Card image
GetPapa + GetSon with variances

Gets the parent folder full name from a path Also Gets the son of a full path. ...

2024Oct26
Card image
CountColumnCells_Unique

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

2024Oct6
Card image
Get boot time

Get the last time Windows 10 was started. Needed this quickly for research.

2024Sep6
Card image
ANmaRead_1stFile

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

2024Aug11
Card image
ANmaCellChar_Superscript_Subscript

Sets certain character inside a cell as superscript or subscript Edit ...

2024Aug11
Card image
Daily folder

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

2024Jul28
Card image
ANmaSpecialFolders

Returns path for a specific special folder in system Passing the name of that ...

2024Jul26
Card image
CountRowCells

Counts how many cells with data in a row, starting from certain column until ...

2024Jun22
Card image
MatchIf6Up

Searches for 6 values in 6 columns and return the row number found in. ...

2024May31
Card image
MatchIf6

Searching for row have 6 matches found in 6 different columns, because we had 5, ...

2024May31
Card image
CountColumnCells_2Criteria

Counts how many cells matching 2 criterias. Just like

2024May1
Card image
ANmaCellFormat

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

2024Apr18
Card image
SortArea4

Sort range of cells by up to 4 columns. Can use any of these columns, not ...

2024Apr15
Card image
ContainerHTMLTag_ReturnBlock

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

2024Apr3
Card image
Just learnt that now

Looks like we cannot have filename (having no extension) and folder in same ...

2024Mar5
Card image
EdgarCIK

Search for company long name in Edgar and returns its CIK Using SEC.gov site ...

2024Feb25
123...1516