Search results 224

Sorted from new to old.

ArraySort_3Cols

Returns the Array of 3 cols after sorting it

Mon 5PM

ANmaRemoveBlanks_1Col

Remove blank cells from 1 column

Sun 7AM

SettingRead_Bulk

Reads list of passed SettingNames with defined separator from Settings and ...

Nov3

GetPapa + GetSon with variances

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

Oct26

CountColumnCells_Unique

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

Oct6

Get boot time

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

Sep6

ANmaRead_1stFile

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

Aug11

Daily folder

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

Jul28

ANmaSpecialFolders

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

Jul26

CountRowCells

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

Jun22

CountColumnCells_2Criteria

Counts how many cells matching 2 criterias. Just like

May1

ANmaCellFormat

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

Apr18

SortArea4

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

Apr15

Just learnt that now

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

Mar5

EdgarCIK

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

Feb25

Send workbook as email attachment

Retro way to send a workbook you are in as an email. Found it in one of my old ...

Feb14

1 2 ...13 14