error

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...

I'm running into a Range of Objects Worksheet Failed Error for some reason and I cant understand why. All I did was add the following code to the set of ranges in the Target Range in the sheet code, and all of the sudden I'm having errors when entering text into the any of the cells within the...

Hello, Some context for this issue. I am trying to move over this whole VBA code to my personal book that is stored in XLSTART and run the macros off that moving forward instead of having them in the reports themself. The code below works fine in the document on its own but doesn't work when I...

I've got this range I'm trying to work with and do the following but I'm getting an error message for application or object-defined error. When I use the full range it seems to be the AB sections that are causing the problem. When I delete everything and just use the AB Range it works fine...

I have run into an issue when attempting to update and add new queries in BI. When adding a SQL query with no additional steps, the preview runs, but when I go to apply it, it doesn't do the query type selection and then doesn't apply the changes. It still notifies me that here are changes to...