Solution Category: Miscellaneous
miscellaneous
Name
Brief Description
Open dialog box to select desired folder
Combine online survey data, column wise, from different worksheets containing aligned data – Note: The 256 column limit that created the need for this routine is a thing of the past. There could be circumstances where it is useful but in general, it is considered obsolete.
Concatenate all cells in range with an optional separator
List all worksheets as a named range using cell ‘A1’.
Remove hyperlinks from cells in selected range – Partly obsolete