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 ...
http://www.experts-exchange.com/Programming/Languages/Visual_Basic/Q_10311546.html
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")...
http://www.experts-exchange.com/Software/Office_Productivity/Office_Suites/MS_Office/Q_113...
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...
http://www.experts-exchange.com/Software/Office_Productivity/Office_Suites/MS_Office/Q_204...
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...
http://www.experts-exchange.com/Software/Office_Productivity/Office_Suites/MS_Office/Excel...
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...
http://www.experts-exchange.com/Software/Office_Productivity/Office_Suites/MS_Office/Excel...
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...
http://www.experts-exchange.com/Software/Office_Productivity/Office_Suites/MS_Office/Excel...
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...
http://www.experts-exchange.com/Software/Office_Productivity/Office_Suites/MS_Office/Q_103...
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...
http://www.experts-exchange.com/Programming/Languages/Visual_Basic/Q_20518840.html
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...
http://www.experts-exchange.com/Programming/Languages/Visual_Basic/VB_Controls/Q_20568999....
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...
http://www.experts-exchange.com/Microsoft/Development/MS_Access/Q_20585962.html
Zones:
MS AccessDate Answered: 04/15/2003 Grade: A Views: 0
