Search results 147

Sorted from new to old.

LXFormat

Formats a number found at end of string to have additional leading zeros to ...

2023Jun30

ANmaVLookup

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

2022Dec23

SettingNameAlreadyFound

Searches for a setting value in set of Settings, in Excel spreadsheet using ...

2022Aug18

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

Delete_Unwanted_Rows

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

2020Apr14

1 2 ...6 ...9 10