Excel Macro (VBA) "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)
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
Excel Macro (VBA) 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)
spreadsheet 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
Excel Functions 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
Excel Macro (VBA) How to pass arguments between procedures ByRef,ByVal Excel(Excel) Macro(VBA) This section describes how to pass arguments when procedures are separated. In the article below, I mentioned that it is easier to read and process the code by separating the procedures... 2023.12.27 Excel Macro (VBA)
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)
Excel Macro (VBA) 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)
Excel Macro (VBA) 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)
Edge 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)