4 Examples to Learn Excel / VBA DateDiff Function 
MS Excel Statistics – Usage by Job, Country, Industry & App Downloads 
How to Get Length of String by VBA Len function? 
How to Close Excel Workbook using VBA Code 
How to Create New Excel Workbook using VBA 
3 Ways of Copy/Paste Value, Formatting, Formulas in VBA / Excel
The Range object in VBA has copy method that can be used to copy/paste the contents from one cell or range of cells to other cells.
Get Today Date in VBA
In VBA, you may get today’s date by: 1- Using Date() function 2- Now() function
Append Data in Excel by Pandas ExcelWriter / to_excel with 2 Examples
How to append new data into existing Excel file. The answer is using Pandas ExcelWriter object.
How to Move Excel Chart from One Sheet to Another
In certain scenarios, you may require to have data in one sheet and the chart created based on that data on its own sheet. So, in that sheet, no tabular data in Excel cells is visible.
Excel / VBA Split – How to Break a String
The Split function is used to break a given string. It returns an array of substrings.
How to Read Excel xlsx File and convert to CSV by Pandas
In this tutorial, we will show you how to read a .xlsx file (an Excel file) and then converting to CSV (Comma Separated Values) by using Pandas (A Python library).
Excel / VBA CStr function
The CStr function is used to convert a value to a string.
How to Create Area Charts in Excel
Select the data in the sheet that you want to create area chart. We have following sample data of top countries with area in Square Kms.
VBA String Array
A string array in VBA can be created by using Dim as follows:
Chr(34): Adding Double Quotes in VBA Strings
So, how to include double quotes in your strings? The answer is using Chr() function with 34 code.
Excel / VBA Chr function
Chr is a Text function in Excel that we may use in the VBA.
VBA Replace Function
VBA Replace function is used to replace a given substring (expression) in the source string.
Delete Excel Range Values/Formulas by VBA ClearContents
The ClearContents is an Excel function that can be used in VBA to remove values and formulas in range.
VBA InStrRev Function
The Excel/VBA InStrRev function (In String Reverse), is just like the InStr function except for it searches the given term from the end of given string.
Fetch 1, 2.. or All Columns by Pandas read_excel usecols
By using usecols parameter, you may specify which columns to get data from the specified sheet.