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

FindZipFile_WShell

Finds the first zip in a folder matching wild cards mask using WScript.Shell ...

Aug2

FindImg_WShell

Finds the first image in a folder matching wild cards mask using WScript.Shell ...

Jul31

ReturnLongestString_Of2

Returns the string that is longer, comparing what is before StrSepa versus ...

Jul2

EdgarCIK

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

Feb25

CutString11

Cuts long string from certain character to certain character with option to ...

Feb24

PivotTable_ShowHideItems

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

Jan23

Converts two bytes to long

Functions to convert two bytes to a numeric value (long), (both little-endian ...

Jan14

ANStringListRead_JSON

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

Jan9

CutLeftNumber

Cuts the left part of string as long as it is number Keeps getting characters ...

2023Dec31

ANmaPivotTable_Clear

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

2023Dec22

Subdomain to a folder

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

2023Oct17

Web.config redirect

Redirect URLs to certain page passing its name. This is web.config from one of ...

2023Aug5

List_of_Names + DeleteNames

List names in a certain workbook into sheet. And Deletes those names. You may ...

2023Jul9

1 2 3 4