How to fix runtime error 424 object required error in Excel 2019
![](/images/site-logo.png)
How to fix runtime error 424 object required error in Excel
The Runtime error 424: Object required occurs when Excel is not able to recognize an object that you are referring to in a VBA code. The object can be a workbook, worksheet, range, variable, class, macro, etc. Some users have also reported that this error occurred when they tried to copy the values of the cells from one workbook to another.
Let’s understand the error through a small scenario. Suppose, I want to check the last field row in a table in a spreadsheet named “First” using the VBA code. To do this, I have added a command button and double-clicked on it and entered the below code in the backend:
Private Sub CommandButton2_Click()
Dim LRow As Integer
LRow = Worksheets(“First”).Cells(Rows.Count, 2).End(xlUp).Row
MsgBox (“Last Row “ & LRow)
End Sub
In this code, Worksheets(“First”) is a data object. If I mistakenly delete this data object and insert any random name (for example - kanada), then it will not be recognized by Excel. When I run this code, I will get the “Run-time error 424”.
Causes of Runtime Error 424 in Excel
The Runtime error 424: Object required can occur due to the following reasons:
- Incorrect name of the object you are trying to refer to in a code.
- You have provided an invalid qualifier to an object.
- You have not used the Set statement while assigning an object reference.
- The object is corrupted.
- Missing objects in a workbook.
- Objects you are trying to call in a code are mistakenly deleted or unavailable.
- You have used an incorrect syntax for object declaration.
- You are trying to perform an invalid action on an object in a code.
- Workbook is corrupted.
Solutions to Fix Runtime Error 424: Object Required in Excel
The VBA error ‘object required’ may occur due to different reasons. Based on the reason, you can follow the solutions mentioned below to fix the error.
1. Check the Name of the Object
The Runtime error 424 can occur when you run the VBA code using an incorrect name of the object. For example, the object name is ‘MyObject’ but you’re using “Backcolor”.
When you click the Debug button, the line with the error will highlight.
To fix the issue, you need to provide the correct name of the object.
2. Check if the Object is Missing
The Runtime error 424 can occur if the object you are referring to as a method is not available or you are using the wrong object in a code. In the below example, you can see that the error occurs when an object named “Employee” is not available in the Project list.
You can check and mention the object which is available. For instance, Sheet2 in the below code.
3. Check All References are Declared in the Code
You can get the Runtime error 424 if all the references are not declared. So, make sure you have declared all the references in the code. To verify this, you can use the debug mode by pressing F5 or clicking on the Debug option.
4. Check the Macro Security Settings
Sometimes, the error can occur if macros are disabled in the Macro Security settings. You can check and change the settings by following these steps:
- On the Developer tab, in the Code section, click Macro Security.
- In the Trust Center window, select Enable all macros.
- Click OK.
5. Repair your Workbook
Sometimes, the ‘Object required’ error can occur if your Excel file is damaged or corrupted. In such a case, you can try repairing the file using Microsoft’s in-built utility - Open and Repair. To use this utility, follow these steps:
- In Excel, go to File > Open > Browse.
- In the Open dialog box, click on the corrupted Excel file.
- Click the arrow next to the Open button and select Open and Repair from the dropdown.
- Select Repair to recover as much data from the file as possible.
If the Open and Repair utility fails or stops working, then you can try a professional Excel repair tool, such as Stellar Repair for Excel . It is an advanced tool that can repair severely corrupted Excel files (.xls, .xlsx, .xltm, .xltx, and .xlsm). It helps recover all the file components, including images, charts, tables, pivot tables, cell comments, chart sheets, formulas, etc., without impacting the original structure.
Conclusion
The Runtime error 424 usually occurs when there is an issue with the objects in your VBA code. In this article, we have covered some effective methods to resolve the “object required” error in Excel. If the error occurs due to corruption in Excel file, then you can repair the corrupt file using Stellar Repair for Excel. It is a reliable tool that can repair severely corrupted Excel file without changing its actual formatting. You can download the free trial version of the software to evaluate its functionality.
Also read:
- How to recover deleted pictures from Oppo Reno 8T.
- How to Repair Broken video files of Lava Agni 2 5G on Windows??
- How to restore wiped videos on Honor
- 4 Ways to Transfer Music from Realme 12 5G to iPhone | Dr.fone
- 5 Easy Ways to Copy Contacts from ZTE Nubia Z60 Ultra to iPhone 14 and 15 | Dr.fone
- How to restore wiped videos on Xiaomi 13 Ultra
- How to Rescue Lost Videos from OnePlus Nord CE 3 Lite 5G
- How to Recover Deleted iPhone 15 Camera Roll Photos and Photo Stream Pictures? | Stellar
- How to retrieve erased videos from Storm 5G
- 4 Ways to Transfer Music from Itel P55+ to iPhone | Dr.fone
- How to Sign Excel 2021 document with Digital Signature - (Tutorial)
- How to identify some outdated your hardware drivers with Windows Device Manager on Windows 11 & 10 & 7
- 5 Easy Ways to Copy Contacts from OnePlus 12R to iPhone 14 and 15 | Dr.fone
- How to retrieve erased videos from Samsung Galaxy XCover 6 Pro Tactical Edition
- How to Rescue Lost Photos from Itel A70?
- How to remove Google FRP Lock on Asus ROG Phone 8 Pro
- How to Rescue Lost Pictures from Oppo K11x?
- How to get back lost photos from Vivo T2 Pro 5G.
- How to retrieve erased videos from Samsung Galaxy A14 5G
- How to play MP4 files on Xiaomi ?
- How to get back lost photos from Itel S23+.
- How to recover deleted photos from Android Gallery without backup on Meizu
- How To Restore Missing Pictures Files from Samsung Galaxy A34 5G.
- How To Restore Missing Contacts Files from Infinix Smart 8 HD.
- How To Restore Missing Contacts Files from Infinix Hot 40 Pro.
- 4 Ways to Transfer Music from Asus ROG Phone 7 Ultimate to iPhone | Dr.fone
- How To Exit Recovery Mode on iPhone 14? | Dr.fone
- How To Restore Missing Call Logs from Vivo V27e
- How to Rescue Lost Pictures from Infinix Note 30 5G?
- How To Restore Missing Contacts Files from Huawei Nova Y71.
- 5 Techniques to Transfer Data from Asus ROG Phone 8 Pro to iPhone 15/14/13/12 | Dr.fone
- How to Rescue Lost Messages from Realme Narzo N55
- How to Recover Deleted Notes from iPhone 14 Pro? | Stellar
- How To Repair iPhone 6 System? | Dr.fone
- How to Repair corrupt MP4 and AVI files of Samsung Galaxy S21 FE 5G (2023)?
- How to Repair Broken video files of Poco X6 on Windows??
- 5 Easy Ways to Copy Contacts from Nokia C22 to iPhone 14 and 15 | Dr.fone
- How To Repair iPhone 11 Pro System? | Dr.fone
- How To Restore Missing Call Logs from Vivo Y36
- How to fix videos not playing with my Honor 100?
- How to Downgrade iPhone 7 without Losing Any Data? | Dr.fone
- How to solve MKV lagging problem in Galaxy A54 5G?
- How to Recover iPhone 13 Pro Max Data From iOS iCloud? | Dr.fone
- How to Fix corrupt video files of Honor Play 8T using Video Repair Utility on Mac?
- 2 Ways to Transfer Text Messages from Honor 70 Lite 5G to iPhone 15/14/13/12/11/X/8/ | Dr.fone
- How to Recover iPhone 15 Plus Data From iOS iTunes Backup? | Dr.fone
- How to Recover Deleted Photos from Android Gallery App on Motorola
- 5 Easy Ways to Copy Contacts from Nokia G310 to iPhone 14 and 15 | Dr.fone
- How To Restore Missing Music Files from OnePlus Open
- How to Stop My Spouse from Spying on My Apple iPhone 11 Pro Max | Dr.fone
- How To Fix Unresponsive Phone Touchscreen Of Poco C55 | Dr.fone
- Updated 4 Simple Methods for Making a High-Quality Recap Video
- Easy steps to recover deleted pictures from Realme Narzo N55.
- In 2024, 5 Easy Ways to Copy Contacts from Samsung Galaxy M54 5G to iPhone 14 and 15 | Dr.fone
- Online signature for PDF v1.0 document
- Thinking About Changing Your Netflix Region Without a VPN On Motorola Edge 40? | Dr.fone
- 10 Best Fake GPS Location Spoofers for Poco X6 | Dr.fone
- Updated In 2024, Get Best Alternatives of VSDC Video Editor on Mac
- How To Unlock a Vivo V29e Easily?
- How To Change Your SIM PIN Code on Your Tecno Camon 30 Pro 5G Phone
- Is your Infinix Note 30 VIP Racing Edition working too slow? Heres how you can hard reset it | Dr.fone
- In 2024, How to Track WhatsApp Messages on Samsung Galaxy A25 5G Without Them Knowing? | Dr.fone
- Ways to trade pokemon go from far away On Tecno Spark 10 4G? | Dr.fone
- In 2024, 3 Effective Ways to Unlock iCloud Account Without Password From Apple iPhone 11
- In 2024, How to Unlock Realme Narzo 60x 5G Phone with Broken Screen
- The Ultimate Guide to Slideshow Maker with Music for 2024
- How to Clone Yourself in Videos with Filmora?
- Unova Stone Pokémon Go Evolution List and How Catch Them For Samsung Galaxy XCover 6 Pro Tactical Edition | Dr.fone
- In 2024, 2 Ways to Monitor Vivo S18 Activity | Dr.fone
- Updated How to Add Subtitles in VLC Media Play for 2024
- How to Change your Apple iPhone SE (2020) Location on Twitter | Dr.fone
- How to Reset Gmail Password on Xiaomi Redmi A2+ Devices
- In 2024, How To Do Poco X5 Pro Screen Sharing | Dr.fone
- 2024 Approved 6 Unexpected Ways Gif Animation Maker That Affect Your Marketing
- Unlocking iPhone 7 Passcode without a Computer
- Updated How to Add Subtitles in QuickTime Player, In 2024
- 2024 Approved Top Hidden Gems Free Speech-to-Text Apps for Mac Without Downloads
- In 2024, A Quick Guide to Vivo X Flip FRP Bypass Instantly
- In 2024, How to Check Distance and Radius on Google Maps For your Vivo T2 Pro 5G | Dr.fone
- New How to Slow Down Time-Lapse Videos on iPhone
- How to Unlock SIM Card on Apple iPhone 14 Pro online without jailbreak
- In 2024, Forgot Apple iPhone 6 Plus Backup Password? Heres What to Do | Dr.fone
- In 2024, The Art of Vertical Storytelling Phone Aspect Ratio Best Practices
- In 2024, iSpoofer is not working On Samsung Galaxy M54 5G? Fixed | Dr.fone
- In 2024, How to Track Vivo V29e Location without Installing Software? | Dr.fone
- Title: How to fix runtime error 424 object required error in Excel 2019
- Author: Nova
- Created at : 2024-05-19 18:32:11
- Updated at : 2024-05-21 02:34:23
- Link: https://blog-min.techidaily.com/how-to-fix-runtime-error-424-object-required-error-in-excel-2019-by-stellar-guide/
- License: This work is licensed under CC BY-NC-SA 4.0.