1004 error

Hi, I am getting 1004 error for the following code, i have checked through many time and still unsure why.. ActiveCell.FormulaR1C1 = "=IF(" & buffer2(0) & "=""yes"",IF(" & buffer2(1) & "=0," _ & buffer2(2) & "*0.07,SUMPRODUCT(" & buffer2(1) & "," & buffer2(3) & ") * 0.07),0)"

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

I'm fairly new to VBA. I have a piece of code which copied all rows that have numeric data in Column K from one spreadsheet to another. This will be run on multiple spreadsheets, which have difference exercise names and job numbers. The exercise as job number only appear in one cell on the...

I am automating the production of a load of output reports, and was getting a 400 Error when I tried to run. I have now narrowed it down and through the err.description have identified it as a 1004 error "The cell or chart you're trying to change is on a protected sheet. To make a change...

Hi, I am facing #1004 Application-Defined Error issue when try to apply below formula with VBA. The actual formula is : =IFERROR( IF(INDEX('Source data'!$D$4:$ES$40003,MATCH($G5,'Source data'!$EF$4:$EF$40003,0),MATCH(H$3,'Source data'!$D$4:$ES$4,0))="N", INDEX('Source...

Good evening all, I've had a read through various posts but due to my lack of knowledge, it is difficult to determine if others are have the same runtime error as me or not. If anyone has any suggestions, I'd be grateful. I have a workbook, that originally contained just the one sheet. The...

Hello, VBA newbie here. The goal of this script is to locate missing data, take user input, and copy a subsequent row of data on another sheet. When I test the script by inputting the missing inventory, I am facing two problems: The MissingDate variable becomes "12:00 am" for its...

Hey team, Hopefully this is an easy one to solve, but sitting here scratching my head on this one. When I run the below code, I get the following error and can't seem to figure out why... Error Run-time error '1004': Method 'Visible' of object '_Worksheet' failed Background Macro that I am...

Appreciate help with understanding how a VBA macro that works fine in Excel 2010 and 2013, but that generates an error (Run-time error '1004': Application-defined or object-defined error) when executing in version 2016 explicitly. The macro is embedded with a sheet in a workbook (the "Index"...

Hi I would like to create macro that imports the newest CSV file. The file name is changing every day and is located in Z:\ drive (no folder here). This folder holds two different file types with same name (.FLG and .CSV) So far I’ve got to the error stage ’Run time error 1004’ file could not...

Error message: Run-time error 1004: Application-defined or object-defined error. Context: I have a userform with a textbox that I am using to enter data which is then written to a cell in an excel sheet. The problem I'm having is that when a quotation mark is entered into the text box it causes...

Error message: Run-time error 1004: Application-defined or object-defined error. Context: I have a userform with a textbox that I am using to enter data which is then written to a cell in an excel sheet. The problem I'm having is that when a quotation mark is entered into the text box it causes...

Hi there, So happy I found this forum of experts. Hopefully someone can help diagnose this error. Sub TransactionIndex() Dim Index As Long Dim Current As Range Dim Row As Range Index = 1 Set Current = Worksheets("Test").Range("D2") Set Row =...

I'm trying to create a change log for 2 different sheets in this workbook. My first one works using: Dim irow As Long Dim icol As Integer For irow = 1 To 65536 For icol = 1 To 6 If Worksheets("Extra Opener Schedule").Cells(irow, icol).Value <> Worksheets("EOS").Cells(irow, icol).Value...

Hey guys, So I keep getting a 1004 on this particular line of code newVal = sht.Range(Cells(4 + (30 * i), j)).Value Sht is a worksheet variable set to one specific sheet in the workbook, newVal has been declared as double, i and j have both been declared as integers. Keeps telling me the...

Hey guys, here is my code: Option Explicit Public Sub TEST() Dim ProjectName As String Dim StartCellRow As Double, StartCellColumn As Double Dim Start As Range ProjectName = Sheets("Sheet1").Range("C1").Text Start = Sheets("Sheet2").Range("A").Find(ProjectName) StartCellRow =...

Hi everyone, Just could use some help with the code below: Option Explicit Option Compare Text Private Sub CopyLoadData() 'Variable declaration Dim StartCellRow As Integer, StartCellColumn As Integer, i As Integer Dim sht As Worksheet Dim region As String, RevDate As String Dim rng As Range...

Good Morning, I keep getting the error that is mentioned in the title when trying to hide a filter in my pivottable. I've googled possible solutions, but i cant figure out how to fix this... I have code previous to this which enables the "A" filter on all my pivots, however I need to hide it...

Hi, I am relatively new to VBA and I am trying to write up a code to be able to filter a pivot table using checkboxes: Sub RentCheck() If Sheets("Dashboard").CheckBoxes("RentCheck").Value = xlOff Then Set pt = Sheets("Pivots").PivotTables("PercentofRevFY15")...

Hello to all, I'm getting a 1004 error when trying to apply a autofilter using a array. Bellow is the line of code in question: Worksheets(CONBaselineSheet).Range("A1:" & GetColumnLetter(CONLastTaskColumn) & GBLProjectFile.TotalTasks + 1).AutoFilter Field:=varField.Field...