ReBizRU

About Variable Types Excel(Excel) Macro(VBA)

This section explains the types used when declaring variables in "Dim Variables". Here are some typical types of variables that you only need to remember. I almost always use only these. Variable typeThe range of data that can be storedstring stringlong integer (-2,14...)

2024.06.14

Excel Macro (VBA)

How to Clear Sheet Data with Excel VBA: Simple Macro Tutorial for Beginners

Tired of manually deleting large amounts of Excel data? This article explains how to delete sheet data using VBA macros with ClearContents, Clear, and Delete—completing the task in seconds.

2025.06.18

Excel Macro (VBA)

How to display the Immediate Window Excel(Excel) Macro(VBA)

One of the skills that you will need to learn as you progress in your VBA studies is the skill of using Immediate Windows. To use it, you must first display the Immediate Window. In this article, we will explain how to display the Immediate Window...

2024.01.02

Excel Macro (VBA)

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

Automatically create invoices from sales invoices 2 Excel (Excel)

Creating Invoices Automatically from Previous Sales Statements1 Continuing from Excel (Excel), we will create an invoice. Putting the details on the invoice (using a function)*Using the "FILTER" function using Spil*This one uses the Spil function, so you will need to use Microsoft365 or E...

2024.06.10

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

How to Prefer Manual Fill to Conditional Formatting Excel (Excel)

Conditional formatting is a very useful feature that automatically fills in or changes formatting based on specified conditions. However, many of you may have experienced the problem that conditional formatting takes precedence over manual filling. In this article, we will discuss how to use conditional formatting...

2024.07.09

Excel Functions

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 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 paste Excel (Excel) images

There are functions to do various things with images, such as sticking an image on Excel or fitting an image into a cell. In this article, we will introduce two ways to import images into Excel. Place the image on top of a cellOnce you save the image to a folder somewhere on your terminal, you can use this method...

2024.05.16

Excel Functions

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