Search results 136

Sorted from new to old.

ANmaHTMLImgDownload

Downloads image from src of < img html tag after searching for list of ...

2023Aug2

IfFoundInList

Checks to see if sStr matches on of the items in Listof, knowing separator, ...

2023Jul24

ANmaHTMLContent

Reads certain part in HTML output of a page. Will search for list of strings ...

2023Jul1

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

1 2 ...5 ...8 9