Advertisement

1 - 10 of 242 containing alltags:("1004") (0 seconds)
Below is my code. My problem is when LastRow is greater than 300 I get unable to set xvalues property error 1004. Any help ? Also I can't seem to get the xvalues to display on the chart, I get ...
Zones: Visual BasicDate Answered: 03/17/2000 Grade: B Views: 0
well I have a sheet with 2      a      9 3      b      5 3      c      2 and I put a button to launch a simple sort procedure with this code : Private Sub SortButton_Click()     Call Range("A1:C3").Sort(Key1:=Range("C1")...
Zones: Ms Office SuiteDate Answered: 09/22/2000 Grade: A Views: 0
Why does it fail to run a macro(using a customized macro button)...compared to executing the same macro step-by-step? Error is: Run-time error 1004? How can one avoid the same...I have tried variou...
Zones: Ms Office SuiteDate Answered: 04/20/2003 Grade: B Views: 0
Here the function which which traverses rows and acts on color of the interior, the error generated is marked below with '**** ERROR 1004 Code excerpt: Private Sub AuditBlok() ' reset blok cou...
Zones: MS ExcelDate Answered: 06/01/2004 Grade: A Views: 0
Hi Experts, I am attempting to create a new Excel Workbook and be able to reference it throw VBA without knowing the default name (ie Book1.xls or Book21.xls). So I have Set XL = CreateObj...
Zones: MS ExcelDate Answered: 01/03/2006 Grade: A Views: 0
I have the following VBA code which I would like to use to export a Chart to a GIF File from Excel.  The only problem is that I get a : Run-Time '1004' Application-defined or Object-defined er...
Zones: MS ExcelDate Answered: 08/15/2007 Grade: A Views: 0
This is a bit of a follow on from the DIF problem which I have had to delete 'cos Excel is just too damn cocky. I have developed a workaround using a WebQuery to get the data (partially formatte...
Zones: Ms Office SuiteDate Answered: 02/29/2000 Grade: B Views: 0
I got your commnet.Thanks a lot ,but still I have problems.Firstly I am not able to place the with statement since it is missing.The code show error 1004 "Bad fle name" when it reaches the code "Se...
Zones: Visual BasicDate Answered: 06/20/2003 Grade: B Views: 0
Excel 2000 9.0.3821 VB 6.3 I have some experience with Visual Basic, but would like some help cleaning up this code and debugging the latest problem. This script is used to grab a file from a...
Zones: VB ControlsDate Answered: 08/13/2003 Grade: A Views: 0
Here is the message I'm getting.  Method 'Worksheets' of Object' _Global' failed.   It runs the first time just fine; however, excel doesn't get shut down properly.   I read that you need to take o...
Zones: MS AccessDate Answered: 04/15/2003 Grade: A Views: 0