Search results 60

Sorted from new to old.

ArraySort_3Cols

Returns the Array of 3 cols after sorting it

Mon 5PM

CountColumnCells_Unique

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

Oct6

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

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

PivotTable_ShowHideItems

Show or hide item (or items) in PivotTable for a certain field. Passing ...

Jan23

ANStringListRead_JSON

Reads array into list of ANString, from [ until ] for the giving array name. ...

Jan9

Frm58

Build needed lines to create string variable having block of HTML. Provide the ...

2023Dec25

ANmaPivotTable_Clear

Clears all filters in PivotTable and hide the [blank] item from list, pass ...

2023Dec22

PrCal_Add_Sort

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

2023Dec2

SendEmailMsgv2023

Sending email using Microsoft 365 account. Edit 2024-01-02: Adding ability to ...

2023Nov12

Subdomain to a folder

Redirects a subdomain into a folder child of main domain, named same as ...

2023Oct17

1 2 3 4