Excel
Tutorials
- Data validation - One of Excel's most underestimated tools...
- Microsoft Office Window Class Names
- The ultimate search. - The Find method, why and how to use it.
- Userforms
- Using and creating array formulae
How-Tos
- 3D sum across all sheets - without VBA!
- Checking if a Workbook is Open in any Excel Instance
- Creating a COM Addin - This article explains how to create a compiled COM addin for a MS Office application
- Creating UDF's - How to create a user defined function in Excel
- Creating/loading a fixed width text file
- Finding the last occupied row or column
- Get the name of the user who currently has the workbook open
- Passing arguments to OnTime and OnAction macros
- Populate a Userform Listbox using ADO - Populate a Listbox on an Excel Userform using ADO
- Saving a Spreadsheet Range as a .bmp image file
- Storing data between sessions
Code Examples
- ADO for Access Objects - How to give users the choice of tables to query
- Hiding the rows with X in Column Y - How to hide rows depending on the value in a column
- Obtaining Column Letter From its Number
- Renaming worksheets sequentially - a function to rename a sheet to a name that may already exist
- WorkbookExists? - How to check if a workbook is open
- WorkSheetExists? - How to check if a worksheet exists
If there is anything in particular you would like to see on the site email suggestions@thecodenet.com.
