Search results 195

Sorted from new to old.

Range2Block

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

2023Mar6

Popup button

List of commands in popup menu. Uses listbox, command button and toggle ...

2022Oct13

HyperlinkFunction

Returns the formula for a hyperlink [=Hyperlink(...) ] to be inserted in a cell. ...

2022Aug24

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

Shape_Select_or_CreateThenSelect

Selects a shape inside sheet to change it, or if not found, it will create it ...

2022Jul21

RemoveDuplicates

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

2022Jul7

Img not found - Temp pic

Showing image not found if img src image is missing

2022May27

ASP Classic Page Cache

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

2022May20

Export2CSV

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

2022May16

OST Outlook file location

Outlook OST (and PST) files to be saved in different location Instruction can ...

2022May12

BrowserSetting

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

2022Apr29

SaveAsHTML_Template

Creates HTML file using template found in a column. Have lines of HTML in a ...

2022Feb5

Too large procedures

No longer than 2.9k lines in a sub Oops. Baaaaad coding habits This also ...

2022Jan29

Old cell value

Nice solution to read value in cell AFTER changed. Needed to have that feature ...

2021Dec30

A is for Alpha

Military way to communicate letters in audio, for me I learned not all required, ...

2021Dec6

1 2 ...6 ...12 13