Search results 348
Sorted from new to old.

VBInstr (or Instr parameters)
The great function InStr I use a lot has a small confusing part. Which string ...

Open different Filestypes
Populate list of filetypes in Application.GetOpenFilename method. This command ...

Styles_DeleteNonStandard
Delete styles from an Excel workbook, any non-standard style will be deleted. ...

CopyRange_NoClipboard
Copies range without using clipboard. Applies formats into a cell (or range) ...

ApplyValidation_DropDown
Adds Validation drop-down to a cell (Data --> Validation --> List), or to a ...

CellSave_Hyperlink
Creates a hyperlink to URL or to cell inside a cell in Excel VBA (or delete it). ...