Search results 109

Sorted from new to old.

Convert_Dash_to_Zero

Convert cells with dashes to zeros. Quick code needed to reset sheet copied ...

2023Mar14

UnixDateTimeNumber

Calculates Unix date/time number of a given date/time. Needed it to pass ...

2023Jan6

Listbox 1st item [Any]

Allow user to select [Any] as first item in list that will deselect all other ...

2022Nov13

FoundinList

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

2022Aug12

Range2ANStr

Converts sheet range to ANString, can work on any continued range, 1 or 2 ...

2022Jul19

ASP Classic Page Cache

Set page to cache at certain time or force cache refresh. Something I found ...

2022May20

BooleanCount

Counts how many values are True (or anything) in an array of boolean values ...

2022Apr22

ListBox_SelectionCount

Counts how many items selected in a listbox (multi-selection listbox). Works ...

2022Apr21

OpenAnyFile

Finally, can have one command to open any file using its default associated app ...

2022Jan28

NMRRank_v2021

Ranks a number among set of numbers. This is part of huge tool, we needed to ...

2021Sep23

Excel ribbon

Add ribbon menu to certain macro-based workbook to run macro, will only be ...

2021Aug13

ServerXMLHTTP stream

Using ServerXMLHTTP object to show (stream or download) and image , or any ...

2021Aug3

Frm81 - FullDetails

Show window of details, can be used to show content for certain cell, or show ...

2021Jun26

Frm6 - ANmaMultiSelect

Give users ability to multi-select from list of items into cells with separator. ...

2021Jun23

ShapeRange_BG

Replaces the background fill of any shape in Excel with an image Not Ready yet, ...

2021Mar27

Regular expressions (Notepad++)

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

2021Mar10

1 2 3 ...6 7