Browse codes

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

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 3 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

Moves an item in listbox up or down Needs Lst1 as listbox name Put code ...

2018Jun2

Converts paragraph to 1 line text or 1 line text to paragraph Mainly used to ...

2018Jun2

Downloads list of domains and prices for register, renew or transfer into ...

2018May25