View Full Version : excel insights


  1. RangetoHTML - Upgraded a function using to export table to HTMLbody Excel vba.
  2. How to use the SEARCH, SUBSTITUTE and REPLACE Worksheet Functions in Excel
  3. How to use the COUNTIF, COUNTIFS and SUMPRODUCT Worksheet Functions in Excel
  4. How to use the CLEAN, FIND and ISERROR Worksheet Functions in Excel
  5. Excel Module (Code) Names
  6. Starting with Excel VBA Code
  7. Excel VBA “ run time error 40036 application-defined or object error”.
  8. Using VLookUp in Excel to Link to Excel 'Tables'