Excel Macro (VBA) How to install .NET FrameWork
What are the versions of the .NET Framework? NET Framework (DotNet Framework) comes in various versions (types of toolboxes) with slightly different tools inside...
Excel Macro (VBA) 
Excel Macro (VBA) How to use the method of variable type "Workbook" Excel (Excel) Macro (VBA)
You can read more about how to use the variable type "Workbook" in this blog. How to use the variable type "Workbook" Excel(Excel)Macro(VBA)Here we will explain the "Workbook" method in a little more detail.Wor...
Excel Macro (VBA) VBA "Overflow occurred." Error cause and remedy (runtime error '6′:)
Cause of ErrorThis error occurs when the data type is not in a format that can be handled, or when the data type exceeds the range of numbers that can be handled. First, let's reproduce the error. As shown in the figure above, we have set up the code to copy the numeric value in cell "B3" to cell "B4".
Excel Functions What does the error message "#VALUE!" mean and what can I do about it?
Error messages are unavoidable when dealing with Excel, and you may be surprised when they suddenly appear. Here are the meanings and countermeasures for these errors. As an example of preconditions, let's make a table like this...
Excel Macro (VBA) How to use the input screen "InputBox" Excel Macro (VBA)
If you want to use values or arbitrary characters that do not exist in Excel, the "InputBox" is useful to easily create an input screen during macro execution. In this article, we will briefly explain how to use this "InputBox".
Excel Functions How to Adjust Column Width and Row Height in Excel (Manual Methods Explained)
Visibility is very poor if the column widths are too narrow to display all of the cell contents, or the row height is too narrow to display the contents. In this article, we will explain how to easily and automatically adjust row height and column width to just the right size. With a macro (VBA)...
Excel Macro (VBA) How to delete a sheet by specifying the sheet name VBA(Macro)Excel(Excel)
As the number of unneeded sheets grows, browsing becomes worse, and Excel itself becomes slower. In such cases, you can use VBA to automatically delete unnecessary sheets. In this article, we will show you how to use VBA to delete sheets at high speed...
Excel Functions SUMIF and SUMIFS Functions Excel
The SUMIF function can be used to change the contents of the total according to conditions, and the SUMIFS function can be used to specify multiple conditions. The reason why and how to use the SUMIF...
Excel Functions The two reasons for garbled csv files and how to fix them [Thorough explanation by an Excel master] Windows version.
"Huh? What is this?" Have you ever opened a CSV file in Excel only to find that the text in the file is a series of unintelligible symbols? Yes, you are now facing a troublesome problem called "garbled characters," which is a common problem that many people suffer from...
Excel Macro (VBA) How to Auto-Resize Excel Columns and Rows with VBA Macros (Copy-Paste Ready)
Struggling with cell misalignment or manual resizing in Excel? This article shows how to efficiently adjust row height and column width using VBA—solved in just a few lines of code by a seasoned macro expert.
English 
日本語