ReBizRU

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)

What is an Excel (Excel) Macro (VBA) Module and Procedure?

When dealing with VBA, you will come across terms such as modules and procedures, which are not used in everyday life. So, here I will explain about modules and procedures. Modules include standard modules, book modules, sheet modules, fo...

2023.12.27

Excel Macro (VBA)

Auto-filter cuts out in the middle, how to fix Excel (Excel)

Have you ever had a situation where you applied an auto-filter and found that the auto-filter was only working on the 20th row, even though data was included up to the 100th row? In this article, we will introduce what you should check when you encounter such a situation. Auto filter aperture...

2024.06.14

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.

Easy with Excel and Word! Mastering the art of address printing that anyone can do!

Have you ever had to worry about writing addresses for New Year's cards and summer greeting cards? Writing dozens of cards by hand is a lot of work, but buying specialized software is also a bit expensive.... Everyone has experienced this dilemma at least once. But the truth is, your computer...

2024.09.22

Excel Functions

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 Create Your First Excel Macro (Beginner’s VBA Guide)

To write a VBA, you start with the "Development" tab, which is not present by default. Click on the File tab, then click on the option...

2024.05.28

Excel Macro (VBA)

How to use Excel (Excel) INDEX and MATCH functions in combination

We will show you how to display the desired data by combining the INDEX function, which refers to data from a table on another sheet, and the MATCH function. How to Write the INDEX Function There are two ways to write the INDEX function. INDEX(array, row number,) INDEX(reference, row number, , )

2024.07.27

Excel Functions

How to set and remove sheet and book protection Excel (Excel)

If you are thinking about preventing Excel mishaps, this is a must! This article details how to set up and remove sheet and book protection. In fact, you can easily set it with a password. This article will help you protect your important data.

2025.06.06

Excel Functions

How to Disable Automatic Calculation in Excel VBA to Speed Up Your Macros

Learn how to disable automatic calculation in Excel VBA to dramatically speed up your macros. Simple code examples and performance tips included. Boost your Excel automation today!

2025.07.28

Excel Macro (VBA)