Search results 50

Sorted from new to old.

VLookup_HTML

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

2024Jan26

VBInstrRev

Similar to VBInstr, but this one does it in reverse, which is instrrev() ...

2024Jan24

Protect txt file into word doc with password

Saves txt file as word doc with password. Passing txtfile having full path and ...

2024Jan4

HMatchIf_Multi

Returns column if an item from list of items was found in a row. Similar to ...

2023Oct30

Subdomain to a folder

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

2023Oct17

OutlookFolder_DuplicatesRemove

Removes duplicated emails in an outlook folder. Originally not my work, ...

2023Jan1

ANmaVLookup

Finds first occurrence of item in column, then returns value from same row as ...

2022Dec23

ANmAdvancedFilter

Filter table inside Excel the fast way (using advanced filter) into another ...

2022Sep15

CreateUniqueList

Create list of unique items from a column into another column This is similar ...

2022Apr26

Win10 Pin shortcuts

Multiple shortcuts to same app in Windows 10 taskbar

2022Apr25

DateDiff_En

Calculates the differences of date (against NOW) and return in English ...

2022Mar3

fNMRPrgs, Full-form progress bar (frm77)

Show progress bar inside userform, with option to control lots of things. This ...

2021Oct5

Highlight row of current month

Highlight row in Excel if it is within current month This is another version ...

2021Sep2

Reset ID Column

How to reset ID Column in Microsoft SQL, (not completed yet). This is because ...

2020Feb9

ASCII_Read + ASCII_Save

Reads or Saves text into file, giving its full path. Same as

2019Oct22

Rows 2 Cell

Convert items found in a column matching certain material into list in 1 cell ...

2019Jul30

1 2 3 4