ReBizRU

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

2024.06.14

Excel Macro (VBA)

Excel to allow entry of items not in the pull-down (drop-down) list

When using the pull-down entry function in Excel with the default settings, if you try to enter an item that is not in the list prepared for entry, an error message like the one shown below will appear and you will not be able to enter the item. In such a case, you can either allow any item to be entered, or display a message...

2025.06.11

Excel Functions

How to pass arguments between procedures ByRef,ByVal Excel(Excel) Macro(VBA)

This section describes how to pass arguments when procedures are separated. In the article below, I mentioned that it is easier to read and process the code by separating the procedures...

2023.12.27

Excel Macro (VBA)

How to correct "###" in cell display Excel (Excel)

When dealing with numbers in Excel, it often happens that the sharpness of the numbers becomes "######" as shown in the title, and the value becomes unreadable. The conclusion is that the reason for the "#####" is that the length of the value is larger than the size of the cell, making it impossible to display...

2024.06.05

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

2024.10.08

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

2025.02.19

Excel Functions

How to Instantly Convert Address Numbers to Kanji Using SUBSTITUTE in Excel.

When printing addresses on envelopes using the address list of a New Year's card or a customer list, for example, horizontal envelopes are written in arithmetic (Arabic) numerals such as "1, 2, 3", while vertical envelopes must be written in Chinese numerals such as "1, 2, 3". Substitute the numbers...

2024.09.20

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)

Top 4 Ways to Write Vertically in Excel: Features, Pros, and Best Use Cases

Excel is normally designed to be written horizontally, but it can also be written vertically. There are several ways to do this, but in this article, we will introduce four methods, two using "cell formatting" and two using "text boxes. Using "Vertical Writing" Cell Formatting1....

2026.07.07

Excel Functions

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