Search results 167

Sorted from new to old.

CreditCardType

Returns credit card type and whether it is valid or not. Found it in my old ...

2023Jul28

Luhn

Luhn function to return true or false if is valid based on Luhn identification ...

2023Jul25

Between_HTMLtag

Returns the full text found between HTML tag open and close by either and index ...

2023Jul22

Refresh Table from View

Convert SQL View into table for speed reading. Using views a lot, I needed a ...

2023Jul19

Enable Blocked Macros in O365 from OneDrive

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

2023Jul10

Excel user name

Get application user name or change it Originally from

2023Jun14

Detailed errors - Web.config

Show detailed error using Web.config Was always struggling with the exact ...

2023May25

Excel recovered files

Location of Excel recovery workbooks in your system when Excel crashes, it ...

2023Mar31

Range2Block

Concatenate all rows found in a range starting A1Cell for Columns_To columns ...

2023Mar6

OutlookFolder_DuplicatesRemove

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

2023Jan1

OutlookFolder_DuplicatesCount

Counts emails with 1 or more duplicates in active folder in Outlook. Still not ...

2022Dec31

Dropdown button commands

A drop-down of multiple commands in pure VBA. Needed this in a large Excel-VBA ...

2022Oct12

RunOnTime

Runs a certain macro on certain time. This is not a scheduler, but just simple ...

2022Sep29

ANmaRemoveDuplicates

Removes duplication in table in 1 or more columns using Excel ...

2022Sep25

RemoveDuplicates

Removes duplicated items from a 1-dim array into new array, does not modify ...

2022Jul7

SQL Related posts

Steps to create related posts query in SQL. Index, catalog, matching posts for ...

2022Jul6

1 2 ...5 ...10 11