error 1004

Hi, I get run time error 1004 when I run the following code, which should synchronize the slicer caches: Private Sub Worksheet_PivotTableUpdate(ByVal Target As PivotTable)Dim sc1 As SlicerCache Dim sc2 As SlicerCache Dim si1 As SlicerItem Set sc1 = ThisWorkbook.SlicerCaches("Slicer_SolName")...

I'm running into a strange problem, for many years I have used these excel macros and all of a sudden I started to receive errors that only appear on one computer. This macro and pivot issue doesn't exist on any other computer I have tried. So excel was uninstalled and a fresh clean updated...

Hi, I have the below code that is working for most of my users but is crashing in the red line for some of the users. The only common trend I've found for those that this is not working is that they are Excel 2013 users as everyone else is Excel 2010. The Excel 2013 users have a run-time error...

Hi guys, I try to filter data that I have in Macro file in DataSheet ('DS'). I need to take filtered data only (w/o header row) & copy it into different workbook/sheet 'SFDCReport', where there is a Table (Header row on line 12, 1 data row on 13). With this code, I received some Error 1004 -...

Hello all, I have a worksheet change event that hides/unhides rows, but when my sheet is protected it doesn't work. now, the sheet is protected in vba uing this: ActiveSheet.Protect "password", _ DrawingObjects:=True, Contents:=True, Scenarios:=True _ ...

Hello all, I am encountering the following error message when I try to generate a PDF from a checkbox list of multiple sheets. "Run-time error '1004': Document not saved. The document may be open, or an error may have been encountered when saving." Any help would be appreciated with helping...

Sheet4.Range("C8").CurrentRegion.AdvancedFilter Action:=xlFilterCopy, _ CriteriaRange:=Sheet4.Range("AM6:AO8"), CopyToRange:=Sheet4.Range("AQ8:AT8") i cant seem to find whats wrong with the codes. can anyone help me with this code. all my table headings is all the same

Dear Experts, I have a large array I need to dump to a range. I read that there are limits on the size of array you can dump, so I wrote this sub to prevent writing too much to the sheet at once. I still get an error when writing row 1385, column 11. This item of data is a string that is...

I have a button that uses the following code to print the information in the range of cells to a PDF: Private Sub CommandButton1_Click()ActiveWorkbook.Worksheets("Sheet1").Range("L2:L35").ExportAsFixedFormat Type:=xlTypePDF, _ Filename:=Filename, _ Quality:=xlQualityStandard, _...

The following code works when I execute it from the WB workbook but returns error 1004 when I run it from WBi workbook I need to run it from WBi Woorkbook. Thx for the help in advance Option Explicit Sub MatchCopy() Dim WB As Workbook Dim WBi As Workbook Dim...

Hi, I'm trying to insert in a range a VLOOKUP formula that will return data from another closed workbook but the line where the formula is inserted returns error 1004 Here is the code: Sub insFormula() Dim c As Range Dim LastRow As Integer With ActiveSheet LastRow = .Cells(.Rows.Count...

I am using an input box to allow a user to create a new file name. The code works well until the user returns to the process and errantly tries to re-create the same file name. When that occurs the Run-time error '1004" msg appears "Method 'Save As' of object'_Workbook' failed. Does anyone...

Hi All, Wondering if you could help me out - I am completely brand new to VBA. I am trying to get specific data to automatically transfer into another worksheet table. I keep getting a 1004 error on the code It would be really great if you guys could help me on this one, thanks! The code...

I am trying to create a column "H" that will display the values in column F unless F is empty. In such a case, the value from column E will be entered into column H, however I am new to using vba and am not sure how to fix this macro as it continues to fail on the first line "If...

Hi Everyone, I hope this will make sense but rather than find, select and delete a row of data in my workbook I wish to cut that data and move it to a secondary tab instead. To explain a little more… In my workbook I have a ‘Master Database’ tab which contains only the most recently entered...

I am using same code in three different functions and it's working fine with two of them but with third one it's giving me "Error 1004: AutoFilter method of Range class failed". I have a long code and I am getting error in this part of the code: - Code:- Public Sub XYZ (fcstartdate As Long...

Hi All, im hoping you can assist me with this error im getting. Run-time Error '1004': Application-Defined or Object-Defined error the code I've used is below, and the problematic part is in bold. any help will be greatly appreciated. Sub Save() Dim shFrom As Worksheet, shTo As...

Hi I am having trouble with my sumifs in vba. It is returning error 1004. I think that it is due to one the word that it is referencing as it has the symbol $ after the word Overtime. I have tried the following: 1. putting in " - however that didn't work as it then reads the characters and...

Hi, I have a loop inside a Sub that copies and pastes values and cell names into a new workbook. Randomly, the loop stopped working. I haven't adjusted this code or any of the cells that it's looking at, so it's very strange. It's causing the Object error 1004. The code is below and I've...

I'm getting an error on a vba code I'm trying to write. For i = 1 To 8 Range(Cells(2, i + 1), Cells(lastrow1, i + 1)).Select Selection.Copy Workbooks("Querypartlist.xlsx").Activate Range(Cells(1 + lastrow1 * (i - 1), 1)).Select (THIS IS SPECIFICALLY...