Error 438 Object Doesnt Support This Property Or Method
Contents |
360 games PC games runtime error 438 object doesn't support this property or method Windows games Windows phone games Entertainment All Entertainment run time error 438 object doesn't support Movies & TV Music Business & Education Business Students & educators run time error 438 object doesn't support this property or method excel Developers Sale Sale Find a store Gift cards Products Software & services Windows Office Free downloads & security Internet vba runtime error 438 object doesn't support this property or method Explorer Microsoft Edge Skype OneNote OneDrive Microsoft Health MSN Bing Microsoft Groove Microsoft Movies & TV Devices & Xbox All Microsoft devices Microsoft Surface All Windows PCs & tablets PC accessories Xbox & games Microsoft Lumia All
Runtime Error 438 Excel 2010
Windows phones Microsoft HoloLens For business Cloud Platform Microsoft Azure Microsoft Dynamics Windows for business Office for business Skype for business Surface for business Enterprise solutions Small business solutions Find a solutions provider Volume Licensing For developers & IT pros Develop Windows apps Microsoft Azure MSDN TechNet Visual Studio For students & educators Office for students OneNote in classroom Shop PCs & tablets perfect for students Microsoft in Education Support Sign in Cart Cart Javascript is disabled Please enable javascript and refresh the page Cookies are disabled Please enable cookies and refresh the page CV: {{ getCv() }} English (United States) Terms of use Privacy & cookies Trademarks © 2016 Microsoft
here for a quick overview of the site Help Center Detailed answers to any questions you might have Meta Discuss the workings and
Microsoft Visual Basic Runtime Error 438 Object Doesn't Support This Property Or Method
policies of this site About Us Learn more about Stack Overflow the run time error 438 vba access company Business Learn more about hiring developers or posting ads with us Stack Overflow Questions Jobs Documentation Tags run time error 438 access Users Badges Ask Question x Dismiss Join the Stack Overflow Community Stack Overflow is a community of 4.7 million programmers, just like you, helping each other. Join them; it only https://support.microsoft.com/en-us/kb/175616 takes a minute: Sign up VBA Object doesn't support this property or method up vote 6 down vote favorite I need to simply count the number of areas on a sheet. The code I have is : Sub areas() Dim i As Long i = Worksheets("Sheet2").Selection.Areas.Count MsgBox i End Sub But for some reason I get the error message "Object doesn't http://stackoverflow.com/questions/21557683/vba-object-doesnt-support-this-property-or-method support this property or method." I have no idea why. This code was basically just copied from the Microsoft website. I can't even get the immediate window to print the Worksheets("Sheet2").Selection.Areas.Count portion. Any quick help? I am using Excel 2010. Thanks. excel vba share|improve this question edited Feb 6 at 11:21 brettdj 38.6k1563110 asked Feb 4 '14 at 16:18 user2907249 1541212 from where did you copy that? –user2140173 Feb 4 '14 at 16:20 The MSDN dev center gives the example of "Selection.Areas.Count" So all I did was add the "Worksheets..." portion. –user2907249 Feb 4 '14 at 16:23 so I can't add in a reference to a specific sheet? –user2907249 Feb 4 '14 at 16:31 add a comment| 1 Answer 1 active oldest votes up vote 10 down vote accepted Object doesn't support this property or method. Think of it like if anything after the dot is called on an object. It's like a chain. An object is a class instance. A class instance supports some properties defined in that class type definition. It exposes wh
here for a quick overview of the site Help Center Detailed answers to any questions you might have Meta Discuss the workings and policies of this site About Us Learn more about Stack Overflow the http://stackoverflow.com/questions/30913248/solved-run-time-error-438-object-doesnt-support-this-property-or-method-wo company Business Learn more about hiring developers or posting ads with us Stack Overflow Questions Jobs Documentation Tags Users Badges Ask Question x Dismiss Join the Stack Overflow Community Stack Overflow is a community of 4.7 https://search.thawte.com/support/ssl-digital-certificates/index?page=content&id=SO25333&actp=RSS&viewlocale=en_US million programmers, just like you, helping each other. Join them; it only takes a minute: Sign up Solved: Run-time error '438' Object doesn't support this property or method - worked previously up vote 1 down vote error 438 favorite I wrote a VBA script that runs through a bank statement finding payments of a certain value. This code ran fine when I wrote it, but when I return to it a couple of months later I get Run-time error '438' Object doesn't support this property or method; here is an extract of the code. Set bankWB = ActiveWorkbook Set bankWS = ActiveSheet For rowcount = 0 To 250 skipline = False time error 438 If bankWS.Cells(rowcount, paidcol) = 5 Then payee = Trim(bankWS.Cells(rowcount, payeecol)) paid = "5" The error occurs on the 'if' line. I'm new to VBA so it's probably an basic error, but I've found various examples that reference cell values in the same way and this worked ok previously (although something has obviously changed). If you Google this error there are lots of results and I see that using 'range' is more common than using 'cell' to reference a single cell, but it's not obvious to me how to easily translate my (x,y) cell variables/loop into a range "A1" type value so I've not tried rewriting the code to use range instead yet. I assume that the object is bankWS.Cells and it's the property rather than the method that is the problem - I want to know what the value of the object is (=property), I'm not trying to do anything with the object (=method) I've seen lots of different ways of writing the cell object, and tried various permutations, none of which make a difference. eg. If worksheet.bankWS.Cells(rowcount, paidcol) = 5 Then If bankWS.Cells.item(rowcount, paidcol) = 5 Then If bankWS.Cells(rowcount, paidcol).value = 5 Then I'm thinking that the code is ok, and that something else has changed but have no clue where to start looking.
[Compare All] SSL Web Server Certificates with EV SGC SuperCerts SSL Web Server Certificates SSL123 Certificates SAN/UC Capable Certificates Wildcard SSL Certificates SSL for the Enterprise Code Signing Certificates for Microsoft Authenticode (Multi-Purpose) Sun Java Adobe AIR Mac Microsoft Office VBA Thawte Trusted Site Seal Install Your Thawte Trusted Site Seal Become a Partner Partner Center Thawte Resellers Getting Started How SSL Works Small Business and SSL SSL and Web Browsers SSL FAQ SAN/UC Capable Certificates White Papers, Data Sheets& Guides Understanding SSL Certificates ... Extended Validation SSL ... Code Signing Securing your Apache Web Server Securing Microsoft IIS ... Case Studies TUI Health nexxus Independent Schools Foundation Certificate Center Check Order Status Renew Buy Additional Add a License Replace Revoke Update Account Partner Center Issue Manage Renew Marketing Support Sales Support Update Account Sorry...Please supply a document ID for the article you are searching for. Contact Support SSL and Code Signing Tech Support Chat Email Technical Support Check Order Status Order Processing Chat Knowledge Center Search Tips Search Contact Us | About Thawte | Worldwide Sites | Feedback Copyright © 2014 Thawte. All rights reserved. | legal notices | privacy policy | repository | site map Thawte is a leading global Certification Authority. Our SSL and code signing digital certificates are used globally to secure servers, provide data encryption, authenticate users, protect privacy and assure online identifies through stringent authentication and verification processes. Our SSL certificates include Wildcard SSL Certificates, SAN /UC Certificates, SGC SuperCerts and Extended Validation SSL Certificates. What is an SSL Certificate? Which SSL Certificate is Right for Me? Why Choose Thawte?