Error Code 438 Vba
Contents |
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 error 438 vba access About Us Learn more about Stack Overflow the company Business Learn more about runtime error 438 vba hiring developers or posting ads with us Stack Overflow Questions Jobs Documentation Tags Users Badges Ask Question x Dismiss Join
Run-time Error 438 Vba
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 Excel VBA: Run-time error '438'
Run-time Error 438 Vba Object Doesn't Support
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 like 201301 201401 201301 201401 201302 201402 201302 201402 201303 201403 201303 201403 201304 201404 201304 201404 error 438 vba excel 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 vote 1 down vote Just replace the line Call ConvertToStdDateFormat(ActiveSheet.ThisRange) by Call ConvertToStdDateFormat(ThisRange) and the code will work (the worksheet where the range is located is stored in the range object itself and can be refe
Way | Trading Add-ins For Excel | Convert Excel Into Calculating Web Pages Excel Web Pages | Produce Clean Efficient VBA Code Every Time | Build Automated Trading Models In
Vba Runtime Error 438 Object Doesn't Support This Property Or Method
Excel | Excel Web Pages | Excel Video Training Forum New Posts run time error 438 vba access FAQ Calendar Forum Actions Mark Forums Read Quick Links Today's Posts What's New? Advanced Search Forum HELP FORUMS Excel General Run-Time microsoft visual basic runtime error 438 object doesn't support this property or method error '438': Object Doesn't support this property or method vba Excel Training / Excel Dashboards Reports If this is your first visit, be sure to check out the FAQ by clicking the link http://stackoverflow.com/questions/25572021/excel-vba-run-time-error-438-object-doesnt-support-this-property-or-method above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. If you don't like Google AdSense in the posts, register or log in above. Click here to view the relaunched Ozgrid newsletter. Page 1 of 3 1 2 3 Last Jump to page: Results http://www.ozgrid.com/forum/showthread.php?t=152661 1 to 10 of 28 Thread: Run-Time error '438': Object Doesn't support this property or method vba Thread Tools Show Printable Version Search Thread Advanced Search April 15th, 2011 #1 rachel.sw View Profile View Forum Posts I agreed to these rules Join Date 15th April 2011 Posts 12 Run-Time error '438': Object Doesn't support this property or method vba Hi all, this is post on what has been a very useful resource in my vba learning! I have the run-time error: Run-Time error '438': Object Doesn't support this property or method in the code at the bottom of this post. Does anyone know why? Normally it highlights the line but there is no highlighting when it errors. Bit of background, I am doing a task for work as told. I know changing the settings on open is bad practice, but that's what the client wants. This is the second excel to open. I am using a VBA that pulls information from the Google Analytics API (see automate analytics) however because of the way the formula is written calculations must be set to manual. I know this is bad design but it is unavoidable (or at least my research so
360 games PC games https://support.microsoft.com/en-us/kb/287114 Windows games Windows phone games Entertainment All Entertainment Movies & TV Music Business & Education Business Students & educators Developers Sale Sale Find a store Gift cards Products Software & services Windows Office Free downloads & security Internet error 438 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 error 438 vba 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