Improve Your Excel.com
Everything you need to improve your Excel in one place!
Home Categories Tips By Email Search Contact Us Other Links Your Questions Answered

  • A Custom Function For Relative Sheet References


  • A Pop-up Calendar for Excel


  • An Improved Custom Random Numbers Function


  • An Improved Custom Random Numbers Function


  • Automatically Resetting the Last Cell


  • Build an Excel Add-In


  • Cell Counting Techniques


  • Cells() property gives a run-time error


  • Changing Sheet Name to match cell, automatically


  • Controlling User Scrolling


  • Create an accumulator


  • Creating a List of Formulas


  • Creating a Worksheet Map


  • Deleting All Empty Rows


  • Determining the Data Type of a Cell


  • Determining the last non-empty cell in a column or row


  • Determining the Number of Printed Pages


  • Does a Worksheet or Workbook Have Code?


  • Easier Time Entries


  • Event macros


  • Event Macros, Worksheet Events and Workbook Events


  • Excel -- Sorting Data -- Programming


  • Excel: Finding cells matching a specific property using the CallByName function.


  • Extracting the n-th Element From a String


  • Getting Started with Macros and User Defined Functions


  • Hide cells when printing


  • How to customize menus and menu bars in Excel


  • How to transform a DataSet to spreadsheet XML for Excel by using Visual Basic .NET and ASP.NET


  • How to use Visual Basic for Applications examples to control UserForms in Microsoft Excel


  • How to Use Your Excel Add-In Functions in VBA


  • How to Use Your Excel Add-In Functions in VBA


  • Identifying Unique Values in an Array or Range


  • Insert sheets to the right


  • Install Macros and User Defined Functions


  • Invoices and other Sequential Numbers


  • Line and Fill Effects in Excel Charts Using VBA - Update


  • Looking up and displaying pictures based on cell value


  • More Custom Functions for Access and Excel


  • Multifunctional Functions


  • Naming Techniques


  • Overview of Visual Basic Editor Debugging Tools


  • Playing a Sound Based on a Cell's Value


  • Put a Permanently Open Calendar on an Excel Worksheet


  • Removing Pictures for a Worksheet in VBA


  • Select All Unlocked Cells


  • Speed up Page Setup


  • Summing and Counting Using Multiple Criteria


  • Synchronizing Sheets in a Workbook


  • Terminating Dependent Classes


  • Toolbars, Custom Buttons and Menus


  • Using Controls on Worksheets


  • Using Custom Number Formats


  • Where to put your code


  • Working Out a Person's Age - An Introduction to Nested IF Statements


  • Working With Names in VBA


  • Worksheets in VBA Coding and in Worksheet Formulas


  • Writing Your First VBA Function


  • Writing Your First VBA Function in Excel


  • You receive runtime error 429 when you automate Office applications


    • Want more tips? Subscribe to our Free Newsletter today and we will send them to you.
    Most Popular Categories |Bar_Charts |Charts |Pie_Charts |Excel Counting |Excel Filters |Pivot_Tables |Excel_Keyboard_Shortcuts |Conditional_Formating |VLookup |Games |Names_and_ranges |VBA_Examples |Macros