Sessions 72

Codes for sessions and temporary memory managements.

Sorted from new to old.

Match4_Until

Search 4 columns with a stop. Tell the function to stop searching after certain ...

Fri 4AM

ANmAddressSame

Checks if passed addresses are referring to same cell regardless of ...

Sep24

ANmAddressRefStyle

Returns type of the cell address, A1 or R1C1 If multiple cells passed, the ...

Sep23

RegSave, RegRead, RegDelete

Windows Registry read, save and delete branch node or key. Three functions use ...

Sep15

StartApp-IfNotStarted

Checks if application is already running, returns 1 or 0 My first function

Aug3

SettingSave + SettingRead for NumberFormat

Reads or applies certain NumberFormat to cell in settings. Same patterns as ...

Apr19

CopyFields_FromTo

Moves strings within cells into other cells, move or copy. Specific task to ...

Apr17

EdgarCIK

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

Feb25

FindLinks xla

Excel Addon to find links in workbook. FindLinks v13.2 From

Feb9

VLookup_HTML

Does a search in 1st column (< td tag) in an HTML table (< table tag), and ...

Jan26

RangeValues

Returns values of all cells in range into 1 string Only non-blank values ...

Jan25

SettingRead_Ajax + SettingRead_Ajax_IntoObject

Two functions to return an output of file into object on page or back to caller ...

Jan12

Excel clipboard bug

Looks like there is a bug in Excel when dealing with copy and paste. Excel ...

2023Dec27

Macro keyboard shortcuts

Assign certain keyboard shortcut to certain macro, or clear that shortcut. ...

2023Dec13

UserChanged_Log4

Adds date to column1 when user enters text in column2. Also, if user remove ...

2023Nov28

AddressReferenceStyle

Change Address style from R1C1 to A1 or from A1 to R1C1. Something I needed ...

2023Nov1

1 2 3 4 5