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

Card image cap
HMatchIf

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

Card image cap
MatchIf (aka VMatchIf)

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

Card image cap
WorkbookOpen_ANmar

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

Card image cap
BrowseWorkbook + BrowseWorkbook_Save

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

Card image cap
ColumnName (newer version of ColumnName_XOffset)

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

Card image cap
DeleteAllShapes

Delete all shapes in a sheet

Card image cap
FixPath, IsThere, IsThere1

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

Card image cap
Col2Combo

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

Card image cap
Filesin_Coll + Filesin_Cells

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

Card image cap
FindName

Finds a name in a workbook, returns true or false

Card image cap
FindSheet

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

Card image cap
Multi-line Textbox focus bug

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