438 Error
Contents |
One games Xbox 360 games PC time error 438 games Windows games Windows phone games Entertainment All error 438 vba Entertainment Movies & TV Music Business & Education Business Students &
Error 438 Access
educators Developers Sale Sale Find a store Gift cards Products Software & services Windows Office Free downloads & security
Error 438 Object Doesn Support
Internet 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 Band Microsoft error 438 media player Lumia All 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
Error 438 Object Doesn Support This Property Or Method
to any questions you might have Meta Discuss the error 438 excel workings and policies of this site About Us Learn more about Stack Overflow the company vb error 438 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 https://support.microsoft.com/en-us/kb/175616 Stack Overflow Community Stack Overflow is a community of 4.7 million programmers, just like you, helping each other. Join them; it only takes a minute: Sign up Excel VBA: Run-time error '438' Object doesn't support this property or method up vote 1 down vote favorite 1 Please help debug: Run-time http://stackoverflow.com/questions/25572021/excel-vba-run-time-error-438-object-doesnt-support-this-property-or-method error '438' Object doesn't support this property or method I'm not sure why my the Function ConvertToStdDateFormat(InputRange As Range) is not accepting the range 'ThisRange' Here's what my input looks like 201301 201401 201301 201401 201302 201402 201302 201402 201303 201403 201303 201403 201304 201404 201304 201404 201305 201405 201305 201405 Below is the code Sub trythis() Dim ThisRange As Range Dim MonthYear_array As Variant start_date_row = 1 end_date_row = 12 With ActiveSheet Set ThisRange = .Range(Cells(start_date_row, 1), Cells(end_date_row, 2)) MonthYear_array = .Range(Cells(start_date_row, 4), Cells(end_date_row, 5)).Value End With Call ConvertToStdDateFormat(ActiveSheet.Range(Cells(start_date_row,1), Cells(end_date_row, 2))) Call ConvertToStdDateFormat(ActiveSheet.ThisRange) End Sub Public Function GetMonthYearFormatted(InputDate) 'InputDate should be in the format "201401" i.e. year(2014)month(01) IPString = CStr(InputDate) monthval = CInt(Right(IPString, 2)) yearval = CInt(Left(IPString, 4)) opDate = DateSerial(yearval, monthval, 1) OPFormatDate = Month(opDate) & "-" & Year(opDate) GetMonthYearFormatted = OPFormatDate End Function Function ConvertToStdDateFormat(InputRange As Range) Dim temp_array As Variant temp_array = InputRan
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 https://search.thawte.com/support/ssl-digital-certificates/index?page=content&id=SO25333&actp=RSS&viewlocale=en_US Questions Jobs Documentation Tags 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 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 error 438 object 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. Thanks
[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?