ReBizRU

Absolute and relative references in Excel (Excel)

Absolute and relative references are explained below. Relative reference: If you want to display the same contents in cell "C3" as in the neighboring cell "B3", enter the following in cell "C3": =B3. If you want to display the same content in cell "C3" as in the neighboring cell "B3", enter the following in cell "C3": =B3

2023.12.27

Excel Functions

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.

2024.02.26

Excel Macro (VBA)

Error display "#DIV/0!" Meaning and Countermeasures Excel

Error messages are unavoidable when dealing with Excel, and you may be surprised when they suddenly appear. If you know the meaning of the error and what to do about it, there is nothing to be afraid of. Meaning of "#DIV/0!

2024.05.30

Excel Functions

Get the path (save location) of the opened Excel file "Path" Excel Macro (VBA)

In many cases, it is useful to be able to get the location of the Excel file you are currently working on when you want 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 "Path" command, which is useful in such cases. The currently open Excel file...

2024.05.30

Excel Macro (VBA)

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...

2024.10.08

Excel Functions

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...

2024.08.23

Excel Macro (VBA)

Measure macro processing time Excel(Excel) Macro(VBA)

When trying to speed up a macro, it is first necessary to be able to determine how much time was saved before and after the improvement, and how much time was saved or not. To do this, it is necessary to be able to measure the time. In this article, we will show you how to do this. In this article, we will discuss the process of...

2024.01.03

Excel Macro (VBA)

How to Disable the Copilot Icon in Excel (4 Simple Ways)

最近Excelで上図のような「Copilot」マークが表示されるようになった方も多くなってきているのではないでしょうか。便利な機能もたくさんあるCopilotですが、セルを選択すると常に出てくるというのはさすがに邪魔な時もあります。そこで今...

2025.07.12

Excel Functions

Auto-filter cuts out in the middle, how to fix Excel (Excel)

Have you ever had a situation where you applied an auto-filter and found that the auto-filter was only working on the 20th row, even though data was included up to the 100th row? In this article, we will introduce what you should check when you encounter such a situation. Auto filter aperture...

2024.06.14

Excel Functions

About Variable Types Excel(Excel) Macro(VBA)

This section explains the types used when declaring variables in "Dim Variables". Here are some typical types of variables that you only need to remember. I almost always use only these. Variable typeThe range of data that can be storedstring stringlong integer (-2,14...)

2024.06.14

Excel Macro (VBA)