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)
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)
Excel Functions How to Insert Rows in Excel Without Breaking Formulas Having trouble with broken formulas after inserting rows in Excel? This article explains step-by-step how to fix them easily using formula copying—shared by an experienced Excel expert. 2025.06.18 Excel Functions
Edge Fix Excel Clipboard Error: 'The Clipboard Cannot Be Emptied' or 'In Use by Another Application' Frustrated by the "File is in use by another application" error during copy and paste? This article provides a detailed explanation of the issue along with both quick fixes and long-term solutions to resolve it effectively. 2025.06.18 EdgeExcel Functions
Excel Functions Excel (Excel) Conditional Formatting Methods Excel has a function to change the format according to cell values and various conditions. Here is an example of a specific setting. Suppose you have a simple table like the one below, and you want to shade in red the cells where no sales have been entered. First, select the range you want to format. Next, select "Home"... 2023.12.27 Excel Functions
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
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
Excel Functions VLOOKUP function gives #N/A or #REF! The VLOOKUP function is a very useful function for handling data, but many of you may have experienced that once you get stuck in the error swamp of #N/A or #REF! In this article, we will discuss how to use the VLOOKUP function to get rid of the #N/A and #REF! 2024.07.05 Excel Functions
Excel Functions Locking cells to protect only a specific range of sheets Excel (Excel) When using the sheet protection function, there is a function that allows detailed usage such as "allow selection and input in this range of cells, but not in other cells". For example, let's say you have a system that automatically creates transfer data when you enter a company name and amount of money as shown below. In this example... 2024.10.08 Excel Functions
Excel Macro (VBA) How to delete a sheet by specifying the sheet name VBA(Macro)Excel(Excel) As the number of unneeded sheets grows, browsing becomes worse, and Excel itself becomes slower. In such cases, you can use VBA to automatically delete unnecessary sheets. In this article, we will show you how to use VBA to delete sheets at high speed... 2024.08.23 Excel Macro (VBA)