MyDevLib

VBA-Excel 281 Visual basic for applications that works only in Microsoft Excel, aka macros

Horizontal match for a value in a row Horizontal MatchIf, returns column ...

2018Jun16

The best Match I created, return 0 if not found, kind of CountIF+Match ...

2018Jun16

Opens Workbook without running AutoMacros and without letting the user know ...

2018Jun16

Asks for Excel file to open, then return the full filename with path if ...

2018Jun16

Gets the column name from a cell address. Returns "E" from "E45", or "BR" from ...

2018Jun15

Delete all shapes in a sheet

2018Jun11

Set of 6 functions to deal with filesystem. Gets current workbook path, ...

2018Jun11

Reads everything in a column (starting from certain cell until blank cell is ...

2018Jun10

Reads files in a specified folder into a Collection, work with VB6 and VBA also, ...

2018Jun10

Finds a name in a workbook, returns true or false

2018Jun10

Finds a sheet in a workbook, if no workbook name passed, it will use ...

2018Jun7

Trick to force textbox with multiple lines and scrollbars to refresh itself ...

2018Jun7