I am running the following code and am getting a Run time 1004 Application-defined or Object Defined Error:
Sub CreatePivotTableFromDB()
Dim PTCache As PivotCache
Dim PT As PivotTable
...
http://www.experts-exchange.com/Programming/Languages/Visual_Basic/Q_21440128.html
Zones:
Visual BasicDate Answered: 08/04/2005 Rating: 7.8 Views: 0
If I use: Sheet1.Rows(RowCt).ClearContents
or: Worksheets("EarningsCal").Rows(RowCt).ClearContents
I get error: Run-time error '1004' | Application-defined or object-defined error
*I also ha...
http://www.experts-exchange.com/Software/Office_Productivity/Office_Suites/MS_Office/Excel...
Zones:
MS ExcelDate Answered: 12/21/2006 Rating: 9.6 Views: 0
When I close excel, no matter if I just open the turn right around in close it or if I open a workbook and close it i get "Run-time error '1004' Application - Defined or Object - Defined error". Ho...
http://www.experts-exchange.com/Software/Office_Productivity/Office_Suites/MS_Office/Excel...
Zones:
MS ExcelDate Answered: 01/31/2008 Rating: 9.8 Views: 0
Hi everyone. I'm new to VBA and was wondering why I'm receiving and error message on the 2nd range I want to copy to a new worksheet.
Every week I get a file with trade details, it's about 40+...
http://www.experts-exchange.com/Software/Office_Productivity/Office_Suites/MS_Office/Excel...
Hello! I have a simpel Worksheet_Change Event that works fine in Excel 2003, but fails in Excel 2007. Whenever the event is triggered I get the Error: 1004 Application-defined or object-defined err...
http://www.experts-exchange.com/Software/Office_Productivity/Office_Suites/MS_Office/Excel...
My goal is for VBA procedure to lookup a value from a list of (key, value) pairs and highlight each (key, value) pair that has been selected. Usage will be to determine which (key, value) pairs ha...
http://www.experts-exchange.com/Software/Office_Productivity/Office_Suites/MS_Office/Excel...
Zones:
MS ExcelDate Answered: 10/14/2008 Rating: 9.2 Views: 0
