error 91

Hi everyone, I have an excel workbook with 2 powerquery queries that produce 2 tables named "success" and "Fail". I have 2 buttons which associated codes are Private Sub Fail_Refresh_Click() Application.Range("Fail").ListObject.QueryTable.Refresh BackgroundQuery:=False End Sub Private Sub...

Hi all I have downloaded the next file. It has a userform that makes a dropdown list for each column and it filters the results (Which i belive it's very cool) The problem comes when i perform some changes to the database, in where i put some values for the last column, as you can see in the...

With this vba-code : If Not DishesDoc.getElementById("ContentPlaceHolder_LblRecetteTempsPrepa") Is Nothing Then Failure = DishesDoc.getElementById("ContentPlaceHolder_LblRecetteTempsPrepa").innerText 'Failure being declared as an object End If I want to scrape data from this piece of...

Set findValue = imageB.Range("X:X").Find(what:=myarray(j, 1), _ LookIn:=xlValues, lookat:=xlWhole) 'Using to match values to original launched data Set searchValue = dashB.Range("X:X").Find(what:=myarray(j, 1), _ LookIn:=xlValues, lookat:=xlWhole)...

I can't figure out what I haven't defined properly. The line: If Not (Intersect(Target, Range("H" & rowNum))) Is Nothing Then Gives the error. Private Sub Worksheet_Change(ByVal Target As Range) Dim rowNum As Integer Dim cellResult As Variant rowNum = ActiveCell.Row - 1...

Hi All, Hope you are all well! I'm struggling to overcome the error in relation to the below code, would anyone be able to help me out? Basically I keep getting the 'Run time error 91' for the bolded section of the below code. In the below I'm searching Column E for the value "4" and if/once...

Good day. I am trying to lookup some Warranty Expiration dates via Internet Explorer and return the results to and Excel spreadsheet. Currently the code is very rudimentary. I have not yet added to code to read serial number from the worksheet or write the results back to the spreadsheet. I just...

Hello, I have a small problem. My code is running half of the time. When I press on my command button, my code works fine. When I repress on it to try something else, my code isnt running and I have an error 91. I press on end and retry my command button and it works fine. I dont know what is my...

Hello In my code to export a query to Excel, I am trying to adapt the code from Titleist23 https://www.mrexcel.com/forum/excel-questions/584129-disable-access-excel-backup-file-vba.html to save and close the workbook and stops making a backup file. This is my code working fine to export a query...

Hello I have a Chart in a Worksheet. In the Chart, I am trying to set xlPrimary axis and xlSecondaryaxis to none. I opened the workbook in Excel and made the changes manually with the Recorder on. This is the recorded macro code: ActiveChart.Axes(xlValue, xlSecondary).Select...

I'm using the following to return links from a search on Google: Sub XMLHTTP() Dim url As String, lastRow As Long Dim XMLHTTP As Object, html As Object, objResultDiv As Object, objH3 As Object, link As Object Dim start_time As Date Dim end_time As Date lastRow =...

Still learning Ms Access vba but learning fast. I am not understanding fully and I am stumped on just on two things of which I am sure solve one, the other will also be solved. Spent the last 2 days with no progress. :( I have a button on my form opening my excel spreadsheet (template)...

Hello and thank you for your time. I have created a report that is shared with clients that has a private sub for when the workbook opens. One of my clients is getting an issue with the bold line of code. Here is some basic information: I wrote the code/created the workbook in Excel 2016...

Apparently this happens when a variable is not defined, but all mine are, as far as I can tell. Also, when debugging, the error appears on the End Sub line. That is, the macro (seems to) exit correctly, but as it exits I get the error msg. If the error box could be forced to not appear it would...

I am developing a spreadsheet for analysing expenses & other costs. The data will be in one of the tabs, the full name of which is not known but we know that the name starts with a known string - in this case "statement". What I want is the end of the name: F_Nam. What have I done wrong ? I...

Hey guys, I am trying to create a pivot table with VBA based off of some data that I have. Here is my code: Option Explicit Dim dolSht As Worksheet, hourSht As Worksheet Dim sumSht As Worksheet, byCustSht As Worksheet, allCostSht As Worksheet Dim ptCache As PivotCache Dim pt As PivotTable...

Hi All, Long time user, first time poster here. I put that down to may other people having the issues I have before I do and then the Gurus here sorting them out in a very well written way so thanks for that. I however have an issue I have been unable to find the resolution to. I recently wrote...

Hey so i am trying to make a macro that executes the find next -> replace all path. Highlight a column and replace certain values in the column with a different value. i have no experience with VBA so i used the record a macro button in excel. The resulting macro gives me an error 91 when i try...

First time writing worksheet_change code and I have gotten 2 codes to work, but I cannot get them to work together. The first piece of code is just to hide and unhide tabs, and it works until I paste the second piece of code which is to replace cell values when entered into a specific range...

Hello! Basically what I'm trying to do is the following: First, determine if I'm in the correct row of cells based on the String value of the cell. i.e If the current cell's string value contains the string AB1 or AB2, go through the entire row. Once that has been determined, I would like to...