ReBizRU

How to Hide Sheet Tabs in Excel – Fast & Easy

A must for Excel system creators and those considering preventing erroneous operations. This article explains with images how to hide sheet headings to prevent unexpected operations. In fact, it can be achieved with only a simple option setting. This article will help you create safe Excel files.

2025.06.11

Excel Functions

How to Install EdgeDriver for Selenium (Beginner’s Step-by-Step Guide)

This article details the installation procedure of EdgeDriver for beginners.Do you want to start web automation with VBA but don't know how to set it up? In fact, it can be easily installed in 3 steps, which will be taught by an Excel operation professional.

2025.07.12

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

2024.05.30

Excel Macro (VBA)

How to use the Spill function Excel (Excel)

I had neglected the "spill" feature implemented in Microsoft365 and Excel2021 for a while because I didn't really understand it, but when I tried it, I found it to be very useful. I found it to be very useful. Moreover, I thought that I could do a lot of things by applying this function...

2024.07.04

Excel Functions

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

2025.02.12

Excel Macro (VBA)

Automatically create invoices from sales invoices3 Excel (Excel)

Continuing from the previous article, "Creating Invoices Automatically from Sales Statements 2: Excel," we will now move on to creating invoices. If you haven't read it yet, please also read "Creating Invoices Automatically from Sales Statements 1: Excel". Putting details on an invoice (using a macro)...

2024.05.16

Excel Macro (VBA)Let's make an invoice from a sales invoice.

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)

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

2025.02.19

Excel Functions

Excel (Excel) to automatically create a backup file every time you save

Here is how to automatically create a backup file every time you save Excel. Display the General Options screen First, display the "Save As" screen. On the Excel screen, click the "File" tab, then click "Save As," then click "So...

2024.01.10

Excel Functions

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