Search results 131

Sorted from new to old.

FoundinList

Finds a matching item of a number in list of numbers. Returns 1 if found, 0 if ...

2022Aug12

Protecting VBA code

Steps to protect VBA project in Excel, posted here for reference mainly. An ...

2022Jul6

Img not found - Temp pic

Showing image not found if img src image is missing

2022May27

Export2CSV

Exports a sheet into CSV file Dynamically finds number of rows/columns and ...

2022May16

BrowserSetting

Detect Browser setting (type or other info) using MSWC.browsertype object. Old ...

2022Apr29

COUNTIFS as Rank

Simplest way to rank among peers. used COUNTIFS in case we need to add more ...

2022Jan1

InStr and InStrRev

How to use InStr and InStrRev VB functions It is silly, I know, but I keep ...

2021Dec6

Subtotal_Indirects

Finds the SUM, COUNT, COUNTA, etc for a range of cells referencing using ...

2021Nov26

HTMLTagAttributeValue

Reads value of certain tag attribute from certain attribute Identify attribute ...

2021May30

CutString8

Cuts a string from certain character to certain character with option of either ...

2021May29

Regular expressions (Notepad++)

How to do regular expressions in Notepad ++ search and/or replace Helpful when ...

2021Mar10

RBU - Simple Registry Backup batch

RBU simply means "Registry Back Up" and is a tiny BAT (batch) file that will ...

2020Sep15

Column2AnString_Unique

Creates list of unique items found in a column, returns string with items ...

2020May6

Delete_Unwanted_Rows

Delete rows in a different way I used to delete rows by looping through those ...

2020Apr14

NameNum

Finding the number of a name, used in a numerology program. Finds the number ...

2020Mar21

IntlIsAlphaCharacter

Test if a character is alphanumeric, regardless of the code page or language ...

2020Mar21

1 2 ...5 ...8 9