Microsoft Excel has lot of built in formulas like Sin(), Avg() and many more, which we discuss in detail in future articles, but apart from that you can write your own functions which will...
- VBA-Excel: Read XML by Looping through Nodes
- VBA-Excel: Create worksheets with Names in Specific Format/Pattern.
- VBA-Excel: Add Worksheets For All The Given Dates Except Weekends and Copy The Common Template In Each Worksheet
- VBA-Excel: Create or Add Worksheets at the Run time.
- VBA-Excel: Change Font, Color, Weight of Table Data in the Word document
- VBA-Excel: Modified Consolidator – Merge or Combine Multiple Excel Files Into One Where Columns Are Not In Order
- Send Mail With Link to a Workbook, From MS Outlook using Excel.
- Send Mail With Multiple Different Attachments From MS Outlook using Excel.