ReBizRU

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

2024.06.14

Excel Macro (VBA)

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

2024.09.12

Excel Functions

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

How to Enable Excel Macros: Fix 'Macro Has Been Blocked' Error Safely

If you are having trouble running Excel macros, you have come to the right place. This article explains how to solve the red band message that appears in version 2203 and later. Actually, it can be easily solved by file saving and property settings. This article will help you solve the macro block problem completely.　

2025.06.12

WindowsExcel Macro (VBA)

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)

Creating a QR Code in Excel (Excel)

QR codes are a very convenient way to tell someone a URL or email address, rather than a string of text. It is a very convenient tool because all the recipient has to do is read it. However, the only way to make them is to create and download them using free sites on the Internet...

2024.05.16

Excel Functions

Automatically create invoices from sales invoices1 Excel (Excel)

There are many useful software systems that automatically output invoices as you record sales data if you pay for them, but many people are unable to install software because they "don't have enough money to pay for it" or "management won't allow it" and are making each invoice by hand...

2024.06.10

Excel FunctionsLet's make an invoice from a sales invoice.

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.

2025.06.27

Excel Macro (VBA)

Forgot Password] How to remove sheet protection Excel (Excel)

I have a "sheet-protected" Excel file that I really need to unprotect, but the person in charge of applying the protection has already left the company or lost the memo, and I don't know the password. In such cases, do I have no choice but to give up? No, you can...

2024.10.29

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