Search results 45
Sorted from new to old.

MinIF and MaxIF in Excel 2010
MinIF to calculate smallest number matching certain criteria, in Excel 2010 ...

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

ChartMaxY + ChartMinY
Calculates the maximum of the chart Y Axis to draw, the shifted one, not exact ...

Textbox focus issue fix
Trick to force textbox with multiple lines and scrollbars to refresh itself ...

WorkbookSaveAsk_ANmar
Asks user to save file (or workbook) using GetSaveAsFilename method. Returns ...

WorkbookOpenAsk_ANmar
Asks user to browse to a file and return full path and file name if they do, ...

Multi-line Textbox focus bug
Trick to force textbox with multiple lines and scrollbars to refresh itself ...

ANStrList functions
Set of functions to manage ANStrList strings, read, save, delete, sort, compare, ...