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 Rating: 3.6 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...
http://www.experts-exchange.com/Software/Office_Productivity/Office_Suites/MS_Office/Q_204...
Zones:
MS OfficeDate Answered: 04/20/2003 Rating: 7.2 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...
http://www.experts-exchange.com/Software/Office_Productivity/Office_Suites/MS_Office/Excel...
Zones:
MS ExcelDate Answered: 06/01/2004 Rating: 7.4 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 Rating: 8.6 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 Rating: 9.0 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...
Zones:
MS OfficeDate Answered: 02/29/2000 Rating: 9.2 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...
http://www.experts-exchange.com/Programming/Languages/Visual_Basic/Q_20518840.html
Zones:
Visual BasicDate Answered: 06/20/2003 Rating: 7.4 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 Rating: 8.2 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 Rating: 8.0 Views: 0
What could I be doing wrong with the process below to be recieving a run time error when I reach the line that starts with "Sheets("summary_output_file").Visible = True"
Thanks,
tim
Rang...
http://www.experts-exchange.com/Software/Misc/Q_20628977.html
Zones:
Misc SoftwareDate Answered: 01/22/2004 Rating: 7.6 Views: 0
