Search results 59

Sorted from new to old.

QuickEncrypt plus others ...

Text encryption/decryption snippet that utilizes the powerful xICE encryption ...

Aug15

ANmaSearch_SpaceFriends and LeftSpaceFriends

Searches for string inside string covering multiple possibilities for space ...

Jul30

ANstr_Column

Reads and concatenate the full HTML or non-HTML of column (ColumnID) from HTML ...

Jul29

ANmaSpecialFolders

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

Jul26

ANmaSearch_QuoteFriends

Searches for string inside string with double-quote possibility If single ...

Jul13

ANmAdd_ThenSort_2Columns

Adds values of 2 cells into 2 columns (usually below them). I used these small ...

Jun1

ANString_Location

Finds the location of a sting inside list of strings with certain separator, or ...

Apr23

ANmaCellFormat

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

Apr18

Concatenate_HTMLColumn

Build a string from a certain column in html table (using < table, < tr, and < ...

Mar14

EdgarCIK

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

Feb25

NumberBeforeString

Cuts a number that would be found before certain word inside a block string. ...

Feb1

XMLRead

Returns array of values by an XML expression from XML file. Xmlfilepath is the ...

2023Nov26

End ( xlDown )

A bug found because of using End(xlDown) Please stop using Range("A1"). ...

2023Aug28

GetAmazonPrice

Reading price of an item in Amazon. An AI-generated function with AI-generated ...

2023Apr3

LstCustomSelection_Refresh

Read list of items from Settings sheet, then Sort, then save, before reading ...

2022Aug31

SaveAsHTML_Template

Creates HTML file using template found in a column. Have lines of HTML in a ...

2022Feb5

1 2 3 4