店長 | Page 2 | ReBizRU（リビズル）

VBA "Overflow occurred." Error cause and remedy (runtime error '6′:)

Cause of ErrorThis error occurs when the data type is not in a format that can be handled, or when the data type exceeds the range of numbers that can be handled. First, let's reproduce the error. As shown in the figure above, we have set up the code to copy the numeric value in cell "B3" to cell "B4".

2024.10.10

Excel Macro (VBA)

How to display file extensions [Windows 11].

For the beginning computer user, there may be little trouble with file extensions not being displayed. However, once you have started to tinker with computers to some extent, there are situations where you may need to change the file extension or process a file differently depending on its extension, so this...

2024.10.08

Windows

Forgot password] How to remove read-only (write password) Excel

Files with a "write password" can only be opened on a read-only basis unless the password is known. However, if you must remove the protection and write to the file, but the person in charge of applying the protection has already left the company, or the memo has been lost...

2024.10.08

Excel Functions

Forgot Password] How to remove sheet protection Excel (Excel)

I have a "sheet-protected" Excel file that I really need to unprotect, but the person in charge of applying the protection has already left the company or lost the memo, and I don't know the password. In such cases, do I have no choice but to give up? No, you can...

2024.10.08 2024.10.29

Excel Functions

For beginners] Explanation of causes of Excel being slow and countermeasures.

Manager, have you ever felt 'kind of heavy' when using Excel? Student Yes, sir! I recently started using Excel to improve my business, but I'm having trouble opening files because it takes so long. ManagerYes, that's right. Many people have the same problem...

2024.10.01 2024.10.02

Excel Functions

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)

For Beginners] Detailed explanation of how to easily operate Edge/Chrome with VBA (summary)

Mr. Sato, teacher, is there any good way to import Web information into Excel? Ms. Sato, a student in the Excel course, asked the question with an enthusiastic expression. Manager, that's right. Actually, you can easily get information on the Web magically by using VBA... I have 20 years of Excel experience...

2024.10.01 2024.10.02

Excel Macro (VBA)

For beginners] Detailed explanation of EdgeDriver installation procedure

EdgeDriver is an indispensable tool for automating Edge browser operations using VBA; it can greatly improve the efficiency of your daily work by automating web operations. However, many people are hesitant to install the first step in this process...

2024.10.01 2024.10.15

EdgeExcel Macro (VBA)

For Beginners] Detailed explanation of SeleniumBasic installation procedure.

SeleniumBasic is a powerful tool that dramatically improves the efficiency of your Excel workflow, and many users who have discovered its power say, "I wish I had known about it sooner..." Many users who have discovered the power of SeleniumBasic say, "If only I had known about it sooner.... However, many people stumble upon SeleniumBasic at the first step of installation. Students...

2024.10.01 2024.10.02

Excel Macro (VBA)

Specific ways to present Excel skills that are useful in job interviews.

You use Excel in your daily work. But are those skills that allow you to say, "I'm good at Excel," really applicable in the job market? Many of us learn the basics of Excel in new employee training and use it in our daily work. Sure, we enter formulas, create graphs...

2024.09.28 2024.09.29

change of occupation