error

I've got this formula but keep getting a run time error (Application-defined or object-defined error). I've read about the error a few times but I don't understand what's causing the problem. It's just a checkbox and I want to replace the formula used based on the status of the checkbox...

hi everyone! I was doing some exercise about Function in VBA when an error occurred(wrong number of arguments or invalid property assignment).Here is the picture. Really needs your help !! thx!!

Hi, I'm trying to split up an Excel in several excels based on a list of values in another Excel. Let's show an example: You see that in the top left Excel there is a list of values. My script starts with the first value 'binnendeuren' and search that value in the first 3 columns of the...

Hello everybody! As the topic title says I'm getting an error message each time Excel 365 starts (fresh restart, after Excel was closed). Maybe there's an issue with one of my Add-Ins, I cannot explain this otherwise. Any help appreciated.

HI all, I'm new to this forum so forgive me if my question has been answered before, but I searched the FAQ and I didn't find an answer. I'm creating an Excel function to perform a statistical test. Basically, the input is a range of cells containing my data set. Then I create an array with...

So the function is working as how I intended, just that after it finishes saving as it keeps the last workbook opened and the last created worksheet still opened. how do I prevent the error from popping up? Sub CreateBranchSheets() Dim BranchField As Range Dim BranchName As Range Dim NewWSheet...

Hi one and all, I am trying to use VBA to put a very long formula into a cell, why such a long formula? Don't ask! When the code is entered into the cell as a formula, manually, it worked fine. But after coding the formula into VBA using multiple next line continuations " _" (because it is such...

Hi guys anyway ignore or terminate this error and write + or - at first cell as a text?

Hi All, There is a problem depicted below. There is a cell B6 with a formula (does not matter what is the formula, a formula in principle), which is shown in cell B7 using FORMULATEXT function. Cell B8 contains this formula in the macro format obtained using the macro recorder. Now the...

I'm trying to make a formula that checks if a code exists in 2 existent columns, if it exists in BOTH, it returns a text, that part works perfectly, I used If, And, Match for it. But when i tried to get the other half, when it exists in only one of both (X-Or) it returns error, because of the...

Hello below is a code I use however sometimes I encounter problems with certain lines that I need them to repeat that step then continue. Looking for some help here, thank you Sub GetDatafromEdge() Dim findby As New Selenium.By Dim driver As New WebDriver 'Set driver = New WebDriver Dim keys...

Hi, I am attempting to use two countif conditions across multiple sheets (which I have named "Tabs" in name manager) to count how many times a job is raised for an item with a certain reference number in a particular year of its ownership. I have used a no. of forum posts to get me to where I...

Hi, So I've been working on like 20 different CSV files, these are all products we sell, the task was to find specifications for each product, the specifications columns could range from 3 to 20. Some CSV files contain 1500 products others 100, different CSV because of the different categories...

I would like to filter my table, then use a macro to go over every ID that is still visible, past this on the form of the next sheet and print that sheet. I made the following piece of code and it works as I want it too. I opened the file to day and tried to save it but I couldn't save it. So, I...

In xlookup you can define what your error response is ~~ =xlookup(a3,b:b,c:c,<whateveryouwantyourerrorresponsetobe>,option,option). Typically I use "" as my error response. However when you copy the cell and paste as value (the result being an error state equaling "") in another cell...

I'm trying to pass data from one excel sheet to another, but when I run the program it gives a "Subscript out of range" error, can someone help me? Public Sub recentFilesSpecificFolder() counter = 14 Dim myFile As String, fileExtension As String Dim myRecentFile As String...

Hello I have a workbook that recives data from an external source (WB01). I am trying to create another workbook (WB02) that looks at certain cells in WB01, as the data in WB01 changes then the this is reflected in WB02. I have both workbooks open and they are in the same folder (I have no...

The "error": The code: Dim oPL As Double, o709 As Double, o710 As Double, o713 As Double Application.ScreenUpdating = False Sheets("Calculation_Sheet").Visible = True ActiveWorkbook.Sheets("calculation_sheet").Activate Note: P666, P709, P710 and P713 are global variables...

Hello, I have been using the same workbook for over a month now with no issues. Today, upon clicking a button that has always worked fine, I get the error "Object library invalid or contains references to object definitions that could not be found". Can anyone help? I am completely stuck and my...