Excel Design Solutions

Site
Web

You are here:

| Login

Excel Environment Templates Data AutoFilter Advanced Filter Pivot Tables Data Validation Names and Ranges Charts Formatting Formulae and Functions Date Lookup Math Logical Text User Defined VBA ADO FSO Forms, Toolbars and Controls User Defined Functions Regular Expressions Classes API Addins SQL

Recommended Blogs

Recommended Forums

Recommended Articles

Recommended Books

Can find what you are looking for? Try our custom Google search:

Excel

AutoFilter - Cut, copy or delete data from a table using criteria
Delete records from a table in one-hit; tends to be more efficient than loop. read more...

Navigate Sheets - Move between tabs with VBA
A sub-routine to move from the active sheet to the next or previous tab. read more...

SUMPRODUCT - count how many leap years elapse between two dates
Two methods to calculate how many leap years elapse between two given dates. read more...

home | articles | downloads | about | contact