error

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

I dont know if i just dont understand things, but as for my understandings this formular just doesnt work for me in this scenario. I want to refer to an already existing name with INDIRECT(). I want this range to end up as my dropdownlist. The name i want to refer to is called "DropDown1"...

Hi, I have written some code that looks for column headings to locate the columns of data required in my formula, thus returning a column number. So logically the best method of creating my formula in the cell is to use the FormulaR1C1 function in vba, however I have been unsuccessful in getting...

Hi I have successfully created the code below using an online tutorial. I have two forms whic are transferring to 2 different databases. The first form has worked no problem. I copied the code below to create the second transfer of data and added the number '1' to differentiate the two. It is...

I have a Power Pivot Table with a Grand Total calculation error. Here is the database: ABIPABAFAIAPAQ1Mailing List 1Capitalization 2Records 3Convertible Class A Voting 4Units Summary 5Capital Summary 623Mr Excel Database45Name1234566Mr Excel7Mrs Excel8Excel Jr9Total10I1I1=C4&"...

Hello, I hope to find you well! I need to protect some fields of an Excel sheet, that contains the following VBA code. However, once I protect, this error is always appearing: Unable to set the hidden property of the range class. Private Sub Worksheet_Change(ByVal Target As Range) With...

HI All, I found some VBA which created a searchable drop-down menu after double-clicking which worked perfectly fine however now when I use it the drop-down appears I then select the entry and then rather than populating the cell it goes totally blank. Please can someone help me. I have no idea...

I have a workbook with Worksh5heet_SelectionChange code. Below is the Code. Every Cell on the worksheet is locked except for: Range("D2:D7,B8,C8,D8,F4:F7,H5:H6,H7:I7,L8,M2:M3,M7M6:T6) Also there is a variable Range which is unlocked: Range("B10:B" & LastLineWithBorder & ",C10:D" &...

I am trying to handle an error in a macro from another workbook, but on error is not working within any error occurring in the macro from another workbook when I use application.run. Anyone know why it is not working and how to solve this? Set wb = Workbooks.Open(workbookpath) On...

Please help, Super simply: I have stock on column G and minimum stock on column F. I want to highlight my stock if it is below the minimum stock through conditional formatting: As you can see, I have made the correct conditional formatting that if my value is equal to or less than F2...

HI, this is my first post. How exciting. Hope someone can assist. I've created a Power Query table (Excel 10) to extract stock data from the one website. The web site has (or should have) 4 Tables that contains the data I require. The only difference being the stock code I am searching. The...

Hello everybody, I currently have the following: Where column: I = quantity J = subtract any number entered from the quantity after which the number entered will be subtracted in column I and disappear in column J so you can enter a new one in the future J = add any number entered from the...

Hello everybody, Whenever I open my excel sheet I get the following message: "We found a problem with some content in "File name xxx". Do you want us to try to recover as much as we can? If you trust the source of this workbook, click yes" It is super annoying. It started happening after I...

Hello everybody, I am currently having a problem with one of my files. I have made an order form where people can order goods from. They download my excel sheet and click on a submit macro which sends out the excel sheet in a PDF file through email. This works perfectly fine when I do it...

Hello everybody, I am currently running an excel file in which I have created an order form that people can fill out with their information and the products that they would like to order. I am using a VBA code (please let me know in the comments if you want me to attach the entire code)...

Hello! I am trying to use the below macro to flag an error message when a date range exceeds 7 days. I have used the below which only applies to the first cell in the column. What must I do to apply it to the whole column, I have 350 rows. Just to let you know column K is a calculation of...

Hello All, I have some VBA code that I need help refining. The problem I am having is inconsistent and unexplained errors, from my research it appears that the issue is with the clipboard crashing. How the VBA code works: I have an embedded Word documents with various bookmarks and reference...