You are here:   articles
  |  Login

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

Loading
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...