Search results 62

Sorted from new to old.

GetPapa + GetSon with variances

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

2024Oct26

HTMLRow_Cell

Returns column with ColumnID ... the full area between < td ...> and < /td> ...

2024Aug4

ANstr_Column

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

2024Jul29

ANmAdd_ThenSort_2Columns

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

2024Jun1

CountColumnCells_2Criteria

Counts how many cells matching 2 criterias. Just like

2024May1

Concatenate_HTMLColumn

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

2024Mar14

FindAncherURL_InHTMLRow

Finds the URL (href tag value) for an anchor inside a table row (tr element) ...

2024Mar4

Send workbook as email attachment

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

2024Feb14

Random Number in SQL

Generate Random number inside SQL using timestamp (GetDate function) One of ...

2024Jan30

Gototop + Circular scroll progress

JS icon to show progress of scroll in webpage having button to go back to top. ...

2024Jan28

Excel clipboard bug

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

2023Dec27

ReNumber_IDColumn_inTable

Reset numbers in ID column, with help from AI. The StoredProcedure will move ...

2023Dec17

SearchinHTMLTable

Search for a word in a certain column in html table and return the full row ...

2023Nov12

ContainerHTMLTag

Returns HTML tag of the container of certain location inside HTML block. ...

2023Oct21

Enable Blocked Macros in O365 from OneDrive

Recent Microsoft 365 Excel blocked macros from running when they are in ...

2023Jul10

Range22DimArray

Imports a range into 2-dimension array. Returns the array, providing range, ...

2023May11

1 2 3 4