ReBizRU

SUMIF and SUMIFS Functions Excel

The SUMIF function can be used to change the contents of the total according to conditions, and the SUMIFS function can be used to specify multiple conditions. The reason why and how to use the SUMIF...

2024.07.04

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

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 use the variable type "Workbook" Excel(Excel) Macro(VBA)

For other variable types, please refer to Excel (Excel) Macro (VBA) about variable types. First, we will explain the basic usage of the variable type "Workbook".

2024.06.14

Excel Macro (VBA)

How to Auto-Resize Excel Columns and Rows with VBA Macros (Copy-Paste Ready)

Struggling with cell misalignment or manual resizing in Excel? This article shows how to efficiently adjust row height and column width using VBA—solved in just a few lines of code by a seasoned macro expert.

2025.06.27

Excel Macro (VBA)

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

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 Install EdgeDriver for Selenium (Beginner’s Step-by-Step Guide)

This article details the installation procedure of EdgeDriver for beginners.Do you want to start web automation with VBA but don't know how to set it up? In fact, it can be easily installed in 3 steps, which will be taught by an Excel operation professional.

2025.07.12

EdgeExcel Macro (VBA)

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

This article provides a detailed, beginner-friendly explanation of how to convert Excel files into Google Sheets. Are you struggling because a client has asked you to submit your data in Google Sheets format? The truth is, the conversion process is easier than you might think. Written by someone with experience in streamlining IT workflows, this guide walks you through the steps clearly and practically.

2025.06.05

googlesheet

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)