excel 2003 vba runtime error 438 Chase Mills New York

Address Massena, NY 13662
Phone (315) 769-9234
Website Link
Hours

excel 2003 vba runtime error 438 Chase Mills, New York

I know changing the settings on open is bad practice, but that's what the client wants. help! I'm on deadline... I tried to take a copy of the excel spreadsheet, assign Excel 2003 (Excel 11.0) references and run that but it still failed.

I am using window vista, microsoft office 2007. Share Share this post on Digg Del.icio.us Technorati Twitter Reply With Quote « Previous Thread | Next Thread » Like this thread? Share Share this post on Digg Del.icio.us Technorati Twitter Reply With Quote Mar 9th, 2010,08:12 PM #6 mvptomlinson Board Regular Join Date Mar 2008 Posts 2,638 Re: 2003 v 2007 compatibility I get the above error and when I press debug, the issue highlighted is the following: Code: graff: adde.TextBox6.Text = "ok" shet = ActiveSheet.Name Set CurrentChart = ActiveSheet.ChartObjects.Add(5, 20, 350, 200)

I've saved the workbook and even saved it as another name.The sheet I imported has a sheet number of 77 while the previous last sheet was 23, could this be a Thank you in advance. All rights reserved. I have no idea what this error means or why it's happening.

more stack exchange communities company blog Stack Exchange Inbox Reputation and Badges sign up log in tour help Tour Start here for a quick overview of the site Help Center Detailed Move all the code from the Workbook_Open event to a routine in a normal module and then call that routine from the Open event using Application.OnTime Ok, I almost followed this: Not the answer you're looking for? I get a Run-time error that says "Unable to set the Hidden property of the Range Class".

INFARMED: 5056387" Set myTypeRange = myTypeRange.Offset(1) End Sub Cheers Shasur:) http://www.vbadud.blogspot.com #3 (permalink) October 9th, 2006, 04:09 AM hugoscp Authorized User Join Date: Sep 2006 Location: , , Now I am trying just to do it as an automatic action when the workbook is closed It will lock any cell within the specified range that is not blank then Does the recent news of "ten times more galaxies" imply that there is correspondingly less dark matter? When the value in B1 changes, the code is executed but fails when it comes to the paste function.

Each coclass has an associated GUID that is called class ID (CLSID). Ozgrid is Not Associated With Microsoft. If you could reply to the notification email of this post with your template, then we can run it with your data and resolve this. Powered by vBulletin Version 4.2.3 Copyright © 2016 vBulletin Solutions, Inc.

Method 'XValues' of object 'Series' failed By whitespaces in forum Excel General Replies: 1 Last Post: November 26th, 2004, 17:36 Bookmarks Bookmarks Digg del.icio.us StumbleUpon Google Posting Permissions You may not The time now is 02:19 AM. Join Date 1st September 2010 Posts 10,911 Re: Run-Time error '438': Object Doesn't support this property or method vba Beaten to it Excel Video Tutorials / Excel Dashboards Reports April 15th, Share Share this post on Digg Del.icio.us Technorati Twitter Reply With Quote Mar 9th, 2010,07:41 PM #4 mvptomlinson Board Regular Join Date Mar 2008 Posts 2,638 Re: 2003 v 2007 compatibility

Programmers combine theory and practice: nothing works and they donít know why Page 1 of 3 1 2 3 Last Jump to page: Quick Navigation Excel General Top Site Areas Settings If you like, you can send through the template as a reply to the notification of this post and we can investigate this for you. Registration is fast, simple and absolutely free . Join Date 1st September 2010 Posts 10,911 Re: Run-Time error '438': Object Doesn't support this property or method vba Comment out the 'On Error...' statements and go to the Tools/Options menu.

It's my first time writing macros. [URL] View 2 Replies View Related Excel 2003 :: Runtime Error For One Particular User Jun 10, 2014 I have a workbook in Excel that The gist of it is that I spawn data from MS Access to MS Excel and kick off an Excel macro to do a LOT of formatting. Here's the macro: Sub VP_Sort_Compet_Win() ' ' VP_Sort_Compet_Win Macro ' Application.Goto Reference:="_VP_Win_v_Compet_Chart_Table" ActiveWorkbook.Worksheets("Sales VP Charts").Sort.SortFields.Clear ActiveWorkbook.Worksheets("Sales VP Charts").Sort.SortFields.Add Key:= _ ActiveCell.Offset(0, 1).Range("A1:A16"), SortOn:=xlSortOnValues, Order:= _ xlDescending, DataOption:=xlSortNormal With ActiveWorkbook.Worksheets("Sales VP Charts").Sort Thanks, Lisa Posted by lalbuerme on 17 Mar 2010Microsoft Excel VersionsRate this: (3/5 from 1 vote) Which version of Excel are you using and how many products do you have in

Remove all the On Error Resume Next statements. The variable 'EngCount is the number of occurances of the serial number (also worked out earlier in the code). To make debugging easier it may be useful to start all modules with the line Option Explicit. How do i figure this out?

The Visual Basic Application show me this missatge : "Run-time error '438' Object doesn't support this property or method" My code is : Sub MACRO() bAlerts = Application.DisplayAlerts Application.DisplayAlerts = False Once it's working you can put the error handlers (or not!) back... It is supposed to copy from the Data3 worksheet but, in fact, its copying from the Data Lookup worksheet. I did select the chart.

Each COM interface has an associated GUID that is called an interface ID (IID). the Dim x as Integer lines). View 6 Replies View Related FileSearch Method In 2007, Run-time Error 445 Object Doesn't Support This Action Sep 14, 2007 I was using the following macro on Excel 2000, 2002 & At a later time, additional functionality is to be added to the DLL component.

Does it! Search Forums Show Threads Show Posts Advanced Search Find All Thanked Posts Go to Page... The mortgage company is trying to force us to make repairs after an insurance claim Which day of the week is today?