ReBizRU

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 Text After a Specific Character in Excel Using RIGHT and FIND

Struggling to extract text after a specific character in Excel when data lengths vary? This article explains how to combine the RIGHT and FIND functions to solve the problem—taught by an experienced Excel formula expert.

2025.06.18

Excel Functions

Linking two pull-downs (drop-downs) without macros (for linking only one set) Excel (Excel)

この記事ではExcelで2つのプルダウンを連動させる方法を解説します。部署選択後に該当社員のみ表示したいけど作り方が分からず悩んでいませんか？実はINDEX関数とMATCH関数で簡単に連動可能。Excel専門家が伝授します。

2025.06.09

Excel Functions

Linking two pull-downs (drop-downs) without macros (when reflected in multiple rows) Excel (Excel)

Excel複数行連動プルダウンを作りたい人は必見！この記事ではマクロなしで複数行のドロップダウンを連動させる方法を詳しく解説します。実はINDIRECT関数と名前定義で簡単に実現できるんです。この記事を読めば効率的な一覧表が作れます。

2025.06.09

Excel Functions

How to find function references with trace arrows Excel (Excel)

If you are confused about reference relationships in Excel functions, you have come to the right place! This article details how to find references using trace arrows. In fact, you can easily visualize the relationship between cells from the formula tab. This article will help you understand complex functions.

2025.06.06

Excel Functions

How to Use Wavy Lines to Crop or Skip Part of an Image in Excel

Master the wavy line technique to compress images in Excel! Step-by-step tutorial showing how to create professional image breaks and save space in your spreadsheets and presentations.

2025.08.07

Excel Functions

Insert rows without breaking formulas (using spil) Excel (Excel)

With Microsoft365 and Excel 2021 or later versions, you can insert, delete, and rearrange rows without breaking the formula by using a feature called Spill. In this article, we will show you a specific example...

2024.09.13

Excel Functions

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

How to display file extensions [Windows 11].

For the beginning computer user, there may be little trouble with file extensions not being displayed. However, once you have started to tinker with computers to some extent, there are situations where you may need to change the file extension or process a file differently depending on its extension, so this...

2024.10.08

Windows

Excel Macro (VBA): How to use the CountIfs function in VBA!　

If you are a beginner who wants to use Excel's COUNTIFS function in VBA, this is a must. This article provides a thorough explanation from basic writing to error handling. In fact, with a few tricks, you can reduce processing time from a few minutes to a few seconds. Read this article and you will be able to efficiently tabulate data from tomorrow.

2025.02.12

Excel Macro (VBA)