Excel Macro (VBA) How to Find the Last Row in Excel Using VBA (Macro Guide for Beginners)
We show you how to search through the data from the top down, and how to start from the bottom row of the Excel file and work your way up.
Excel Macro (VBA) 
Excel Functions Excel RIGHT and LEFT functions to extract a specific number of characters from the right or left of a string
I want to display only the four characters from the right of the data entered in a cell, or I want to display the rest of the data without displaying the left few characters. Conversely, I want to display only 4 characters from the left of the data entered in a cell, or I want to display the rest of the data without displaying the few characters on the right. Thus...
Excel Functions How to use the sheet protection function.
After you have created a great system or tool in Excel, do you ever have this fear when you want others to use it? What if someone accidentally breaks a formula... What if an important function is deleted? I only want to edit the cells I need, but...
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) 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.
Excel Functions How to extract characters before a specific character "LEFT and FIND functions in Excel"
As shown in the figure below, if there is extra data after the string and you want to extract only the string to the left of the extra data, you cannot simply use the LEFT function alone because the number of characters is not constant. Function to extract the left side of the "¥" mark in cell "A2" = LEFT(A2,FIND(...))
Excel Macro (VBA) The Complete Guide to IF AND in VBA｜Thorough explanation from basic syntax to practical techniques
I want to combine IF and AND statements in VBA, but I don't know how to write it..." I have experienced such a problem. Actually, the way to write it is a little different from the IF function in Excel. In my 20 years of Excel work, I have used IF AND in VBA to automate many tasks...
Excel Macro (VBA) How to display the Immediate Window Excel(Excel) Macro(VBA)
One of the skills that you will need to learn as you progress in your VBA studies is the skill of using Immediate Windows. To use it, you must first display the Immediate Window. In this article, we will explain how to display the Immediate Window...
Excel Macro (VBA) PrintOut" printer and automatic printing Excel(Excel) macro(VBA)
Have you ever had the experience of printing the same Excel file every time, only to have to set it up again and again? Have you ever had such an experience? Many people spend a lot of time on Excel printing. Especially in an environment where multiple printers are used, it is a big hassle to change print settings...
Excel Functions How to set and remove sheet and book protection Excel (Excel)
If you are thinking about preventing Excel mishaps, this is a must! This article details how to set up and remove sheet and book protection. In fact, you can easily set it with a password. This article will help you protect your important data.
English 
日本語