error 1004

Hi All Im creating a macro which inserts formulas and then autofill the column to last the last row. All formulas works except this one: Range("J2").Select ActiveCell.FormulaR1C1 = _...

Hi guys, I'm pretty new to VBA. I know there are some similar threads on here which have similar issues, I've worked my way through them and I'm still at a loss as to why my code won't work. I'm trying to create a button which will save the workbook to a certain location using the contents of...

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

Olá, fiz uma parte do codigo em uma planilha separada pois a que é a planilha final está muito pesada com codigos. Na planilha separada o codigo roda perfeitamente, porém quando copio e colo na planilha final ela da um erro: "erro de definição de aplicativo ou de definição de objeto - 1004"...

Dear All, Using VBA code as given below, I get an error message (error 1004, Method SaveAs of object_Workbook failed) while saving the second worksheet (marked with *** behind the code line). It seems it has to do with saving twice in a row from the same Workbook. At least that is what I have...

I am trying to write a macro with VBA that will copy the data from my table in a sheet tiled "Front End" to a table on another sheet called "Raw Data". here is my code so far for the copying and pasting into the other sheet in the next empty row. I keep getting error that says "application...

I had this code working with no problem, now it's giving me an error '1004' Document not Saved. Document may be open, or an error may have occured when saving. Don't know where I went wrong...any help is appreciated. Sub savetopdf()' ' savetopdf Macro ' Dim saveFileName As String Dim...

Hi! Please help me to solve a problem. I have Excel’s reports created by some analytic software. There are many data there. One of my actions is to apply AverageIf function for two columns (average from L column based on G column criteria). Moreover L column numbers originally go as a text...

Little background to my question. (Office 2010, if it helps) I'm working on the project which should do pretty simple thing - take data from two sources and make printable pages (mean align data on the page properly, so it looks nice when printed). The problem is - both sets of data should be...

Hello everyone. I just recorded a Macro that copies a table from a spreadsheet and pastes it on another cell. It turned out that it gives the error "1004 a table cannot overlap another table". I figured out that it is happening because the table name is fixed to a String that does not vary by...

Hi Gurus, I have been facing a problem that I am unable to solve by myself. I am copying and pasting a few worksheets from a SharePoint site into a local file. Some of the worksheets are lists so I have to differentiate among them. Nonetheless Excel will not allow me to paste in the local...

I AM STRUGGLING WITH GETTING THIS PIECE OF CODE TO WORK. i KEEP GETTING "APPLICATION DEFINED ERROR AND OBJECT DEFINED ERROR" AND CANT SEEM TO FIGURE OUT WHY. IT ALL LOOKS CORRECT TO ME. PLEASE HELP ME OUT Dim source As Worksheet Dim destination As Worksheet Dim emptyColumn As...

Hi everybody, I met a problem when creating multiple series in one chart using a macro. All the series have the same range for X axis but different range for Y axis. The number of series is a variable, and I tried to define the X and Y axis ranges for each series respectively using a loop...

Group, I've written a macro to copy a part of a row from one workbook into another. This macro has run for many hours without fail (it's moved data from 14,400 workbooks so far). Unfortunately it is stopping on one specific workbook and I can't figure out why. Here's the code I've written...

As the title says, when I try and create a PivotTable using a VBA function (I'm using the first method on this page), it returns the following error: "Run-time error '1004': Application-defined or object-defined error" According to Microsoft's page about the error that it is a catch-all for...

Hello, In below standing code, I got stuck on a 1004 error that tells me: "unable to get worksheetfunction class networkdays". Marked in red. However, one line before this function has also been used to calculate the difference between two dates. Does someone have a suggestion how to resolve...

Hi all, I am trying to set the values in column B in my Workbook "Copy of Dash Board Shell" (shown in the image below) equal to the value derived from my HLOOKUP function from my data workbook shown as second image below Copy of Dash Board Shell Data file so esentially the code will find a...

I am actually fairly new to VBA coding and is at the point where I am trying to learn how to debug a current program given to me by a coworker that I wish to understand and possibly improve to suit my needs. Public Sub Patient_Records() Dim FF As Long, strText As String, strFile As...

Hi. I need to delete rows from a ListObject very fast, based on criteria applied on a date column. I get the 1004 Delete method of Range class failed error on the EntireRow.Delete line: Sub DeleteOldPhoneCalls(ByRef tblCalls As ListObject) Dim rngDelete As Range...

Dear all, I am having difficulties with an, what i think, easy macro. I made multiple macro's to change the filter(date) of a pivot. All these pivots are based on different databases. Sometimes when i fill in a date that the pivots need to filter on, it gives me an 1004 error. This is due to...