Error 438 Excel Vba
Contents |
here for a quick overview of the site Help Center Detailed answers to any questions you might have Meta Discuss the workings
Excel Vba Error 1004
and policies of this site About Us Learn more about Stack excel vba error 424 Overflow the company Business Learn more about hiring developers or posting ads with us Stack Overflow Questions Jobs
Excel Vba Error 438 Object Doesn't Support
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; excel vba runtime error 438 combobox 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 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 run time error 438 vba access 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 = InputRange For colsC = 1 To UBound(temp_array, 2) For rowsC = 1 To UBound(temp_array, 1) temp_array(rowsC, colsC) = GetMonthYearFormatted(temp_array(rowsC, colsC)) Next rowsC Next colsC InputRange.Resize(UBound(temp_array, 1), UBound(temp_array, 2)) = temp_array ConvertToStdDateFormat = Null End Function excel vba range runtime-error share|improve this question asked Aug 29 '14 at 16:04 WonderWoman 21115 add a comment| 1 Answer 1 active oldest votes up v
360 games PC games
Microsoft Visual Basic Runtime Error 438 Object Doesn't Support This Property Or Method
Windows games Windows phone games Entertainment All Entertainment run time error 438 vba outlook Movies & TV Music Business & Education Business Students & educators
Object Doesn't Support This Property Or Method Vba Excel
Developers Sale Sale Find a store Gift cards Products Software & services Windows Office Free downloads & security Internet http://stackoverflow.com/questions/25572021/excel-vba-run-time-error-438-object-doesnt-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 https://support.microsoft.com/en-us/kb/287114 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
VBA Code & Other Help Excel Help [SOLVED] Run-time error 438: Object doesn't support this property or method If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: http://www.vbaexpress.com/forum/showthread.php?48304-Run-time-error-438-Object-doesn-t-support-this-property-or-method click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. Results 1 to 3 of 3 Thread: Run-time error 438: Object doesn't support this property http://www.runtimeerrorsolution.com/how-to-fix-microsoft-excel-runtime-error-438/ or method Thread Tools Show Printable Version Subscribe to this Thread… Display Linear Mode Switch to Hybrid Mode Switch to Threaded Mode 11-30-2013,07:42 PM #1 El_Diabolo View Profile View Forum Posts View Blog Entries View Articles VBAX Regular error 438 Joined Sep 2013 Posts 57 Location Run-time error 438: Object doesn't support this property or method Hi All, I have run into the above error while trying to use variables for workbook and worksheet names. The workbook in question is the active workbook and the sheet exists. I have tried searching for the solution, but I have not found it and I can't figure it out. There may be other ways to do it, but time error 438 I would like to know what is wrong with this code please. Dim wkbDest As Workbook Dim TP As Worksheet Set wkbDest = Workbooks("Table Plan for Cameron.xlsm") Set TP = Worksheets("TablePlan") wkbDest.TP.Range("A1:H24").Clear ' This is where the error 438 happens Formatting tags added by mark007 Many thanks. Reply With Quote 11-30-2013,09:13 PM #2 EirikDaude View Profile View Forum Posts View Blog Entries View Articles VBAX Contributor Joined Sep 2009 Posts 148 Location Would using "wkbDest.TP.Range("A1:H24").ClearContents" do the trick? -edit- Nevermind, the problem isn't the function called, it's with how you define your objects. You need to do it like this: Option Explicit Sub test() Dim wkbDest As Workbook Dim TP As Worksheet Set wkbDest = Workbooks("Table Plan for Cameron.xlsm") Set TP = wkbDest.Worksheets("TablePlan") TP.Range("A1:H24").Clear ' This is where the error 438 happens End Sub Formatting tags added by mark007 Reply With Quote 12-01-2013,06:37 AM #3 El_Diabolo View Profile View Forum Posts View Blog Entries View Articles VBAX Regular Joined Sep 2013 Posts 57 Location Thanks (again), Eirik. Works perfectly. I think Vikings are just great. Best regards. Reply With Quote Quick Navigation Excel Help Top Site Areas Settings Private Messages Subscriptions Who's Online Search Forums Forums Home Forums Announcements Announcements Introductions VBA Code & Other Help How to Get Help Non English Help Access Help Excel Help SUMPRODUCT And Other Array Functions Excel BI Outl
error occurs the user receives the error message Run-time error 438 Object doesn't support this property or method. Basically this error arise when a user start to create a custom toolbar in Excel sheet and the user show the failure message format "Run-Time Error ‘438' . Symptoms of this "Run-Time Error ‘438' – If a user try to create a toolbar in Microsoft Excel by using the Microsoft VB (Visual Basic) application code at that time receive the below given error message. Run-time error "438": Object doesn't support this property or method. Cause of the "Run-Time Error ‘438' – If a user creates a macro which will be work successfully in Microsoft word but may be it not work in Microsoft excel and when you will be try to execute this macro in Excel sheet you can receives run-time error ‘438' (Object doesn't support this property or method) This error occurs if a user creates a button which displays the AutoSum symbol by assigning a particular number to the button and if excel is unable to creates a button with that same number, when the user try to allocate a macro to run that button which has not any existence inside the Excel sheet. At such time it is possible to happen run time error ‘438'. A user can get the error code in macro when it is start to run because this happen due to the object which is not supported by the property or method. So it is most important to resolve Excel Runtime Error 438 from the System. Solution of Excel Runtime Error 438- As we know this problem occurs due creation of macro by the user which is not existence in MS Excel and if the user try to run this macro which object doesn't support the property or method it returns error message to the user. This problem will be solved if the users have more knowledge in programming language to write the code in to the VBA module and it is possible to modify the code as per specific requirements of the user. If the users have limited programming knowledge he or she can contact with Microsoft Advisory Services. Category: Runtime Error Tags: complete guide to solve runtime error 438, fix Microsoft excel runtime error 438, fix runtime error 438, get rid of runtime error 438, how to fix runtime error 438