ReBizRU

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 Disable the Copilot Icon in Excel (4 Simple Ways)

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

2025.07.12

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 Fix Missing Sheets in Excel (Step-by-Step Guide)

This article explains how to solve the sheet heading hiding problem in Excel from the options settings. Have you ever had trouble finding a sheet in a file created by someone else? This article is written by the author, who has experience in supporting Excel operations.

2025.06.06

Excel Functions

For Beginners] Detailed explanation of SeleniumBasic installation procedure.

この記事ではSeleniumBasicの詳細なインストール手順を初心者向けに解説。インストールで躓いて自動化を諦めてしまいそうになっていませんか？実は一つ一つ丁寧に進めれば誰でもインストール可能です。20年のエクセル指導経験ありのプロが伝授します。

2025.06.16

Excel Macro (VBA)

How to Create a Petty Cash Log in Excel (Invoice-Compliant Template Guide)

Many companies and sole proprietorships use petty cash to keep track of personal and company finances. However, it is very time-consuming and error-prone to keep balances and to post the information in the cash book to the accounting system...

2024.05.30

Let's Make SeriesLet's make a petty cash book.

How to install .NET FrameWork

What are the versions of the .NET Framework? NET Framework (DotNet Framework) comes in various versions (types of toolboxes) with slightly different tools inside...

2024.10.01

Excel Macro (VBA)

How to display time in 15-minute increments (CEILING and FLOOR functions) Excel

In the last issue, we introduced how to use the TIME function to display the time in 15-minute increments, 30-minute increments, etc. (TIME function) Excel pointed out that it would be easier to use the CEILING and FLOOR functions...

2024.06.18

Excel Functions

How to Convert Excel to Google Sheets (Step-by-Step Guide for 2025)

This is a detailed beginner's guide to the specific steps for converting an Excel file to a Google Spreadsheet. Are you having trouble when your clients ask you to submit your work in spreadsheet format? The author, who has experience in streamlining IT operations, will teach you how to do it.

2025.06.05

spreadsheet

How to Find the Last Row in Excel Using VBA (Macro Guide for Beginners)

We show you how to find the data from the top of the data and how to start from the bottom row of the Excel file and work your way up.

2025.05.30

Excel Macro (VBA)