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) 
Edge Digital certificate can no longer be selected when logging in to a site (Edge)
Have you ever seen the following error message when using login with a digital certificate? The certificate you have selected is not available for this service. Please close all browser windows and try again. Internet ban...
Excel Functions Locking cells to protect only a specific range of sheets Excel (Excel)
When using the sheet protection function, there is a function that allows detailed usage such as "allow selection and input in this range of cells, but not in other cells". For example, let's say you have a system that automatically creates transfer data when you enter a company name and amount of money as shown below. In this example...
Excel Macro (VBA) Get the full path (save location and file name) of the opened Excel file "FullName" Excel (Excel) Macro (VBA)
There are many situations where it is useful to be able to retrieve the location of the Excel file you are currently operating on when you are trying to retrieve values from another Excel file or save a file as a name using a macro. In this article, we will show you how to use the "FullName" command, which is useful in such cases. The currently open...
googlesheet 2 Easy Ways to Hide or Show Zero Values in Google Sheets
Looking to hide zero values in Google Sheets? This must-read guide explains two easy methods—using custom formatting and the IF function. Discover how to instantly clean up your tables and boost the visual quality of your documents. Would you like a slightly shorter or more technical variation as well?
Excel Macro (VBA) [For Beginners] Detailed explanation of how to easily operate Edge/Chrome with VBA (summary)
Mr. Sato, is there any good way to import Web information into Excel? Ms. Sato, a student in the Excel course, asked the question with an enthusiastic expression. Manager, that's right. Actually, you can easily get information on the Web magically by using VBA... I have 20 years of Excel experience...
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) How to use the property 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" property in a little more detail.Wo...
Excel Macro (VBA) Excel Macro (VBA): How to use the CountIfs function in VBA!
If you are a beginner who wants to use Excel's COUNTIFS function in VBA, this is a must. This article provides a thorough explanation from basic writing to error handling. In fact, with a few tricks, you can reduce processing time from a few minutes to a few seconds. Read this article and you will be able to efficiently tabulate data from tomorrow.
Excel Macro (VBA) Macro suddenly stopped working Excel(Excel) Macro(VBA)
I have been experiencing a phenomenon around me where macros suddenly stop working after having been used normally until yesterday. The phenomenon is that I had set up a macro that is activated by double-clicking on a specific cell, but it no longer responds when double-clicked. I went to "Develop..." to check the contents of the macro.
English 
日本語