+ Reply to Thread
Results 1 to 6 of 6

Object doesn't support this property or method (Error 438)

  1. 02-14-2017, 11:07 AM #1
    VAer
    VAer is offline
    Forum Contributor
    Join Date
    09-10-2016
    Location
    USA
    MS-Off Ver
    Office 365
    Posts
    680

    Object doesn't support this property or method (Error 438)

    is it wrong ti write the code like this?

    Thanks.

    Please Login or Register  to view this content.
    Reply With QuoteRegister To Reply
  2. 02-14-2017, 11:10 AM #2
    YasserKhalil
    YasserKhalil is offline
    Forum Expert
    Join Date
    04-23-2009
    Location
    Matrouh, Egypt
    MS-Off Ver
    Excel 2013
    Posts
    6,892

    Re: Object doesn't support this property or method (Error 438)

    May be
    Please Login or Register  to view this content.
    < ----- Please click the little star * next to add reputation if my post helps you
    Visit Forum : From Here
    Reply With QuoteRegister To Reply
  3. 02-14-2017, 11:11 AM #3
    Norie
    Norie is offline
    Forum Guru Norie's Avatar
    Join Date
    02-02-2005
    Location
    Stirling, Scotland
    MS-Off Ver
    Microsoft Office 365
    Posts
    19,643

    Re: Object doesn't support this property or method (Error 438)

    You should first set WB to reference a workbook then set WS to reference a worksheet in WB and then use something like this.
    Please Login or Register  to view this content.
    If posting code please use code tags, see here.
    Reply With QuoteRegister To Reply
  4. 02-14-2017, 11:12 AM #4
    VAer
    VAer is offline
    Forum Contributor
    Join Date
    09-10-2016
    Location
    USA
    MS-Off Ver
    Office 365
    Posts
    680

    Re: Object doesn't support this property or method (Error 438)

    I think I need to take WB out, since it is in the loop For Each WS In WB.Worksheets
    Reply With QuoteRegister To Reply
  5. 02-14-2017, 11:13 AM #5
    VAer
    VAer is offline
    Forum Contributor
    Join Date
    09-10-2016
    Location
    USA
    MS-Off Ver
    Office 365
    Posts
    680

    Re: Object doesn't support this property or method (Error 438)

    @Norie
    @YasserKhalil
    Thanks.
    Reply With QuoteRegister To Reply
  6. 02-14-2017, 11:15 AM #6
    YasserKhalil
    YasserKhalil is offline
    Forum Expert
    Join Date
    04-23-2009
    Location
    Matrouh, Egypt
    MS-Off Ver
    Excel 2013
    Posts
    6,892

    Re: Object doesn't support this property or method (Error 438)

    Do you mean that
    Please Login or Register  to view this content.
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] VBA debug - Error 438 - Object Doesn't Support this Property or Method
    By The_Snook in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 09-28-2016, 07:59 AM
  2. [SOLVED] Getting run-time error 438 object doesn't support this property or method
    By mso3 in forum Excel Programming / VBA / Macros
    Replies: 10
    Last Post: 08-18-2016, 06:24 AM
  3. Error Object doesn't support this property or method
    By rongil20 in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 10-14-2015, 06:57 AM
  4. object doesn't support this property or method (runtime error 438)
    By studentblob in forum Excel Programming / VBA / Macros
    Replies: 10
    Last Post: 01-10-2015, 09:18 AM
  5. Object Doesn't support this property or method Error
    By andrew c. in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 06-13-2011, 02:07 PM
  6. error '438', Object doesn't support this property or method.
    By ironmonkey888 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 09-23-2010, 09:23 AM
  7. Object doesn't support this property or method (Error 438)
    By Kiran in forum Excel General
    Replies: 1
    Last Post: 07-12-2005, 04:05 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1