+ Reply to Thread
Results 1 to 10 of 10

"Run time error 438, Object doesn't support this property or method."

  1. #1
    Forum Contributor
    Join Date
    11-04-2012
    Location
    Czech Republic
    MS-Off Ver
    MS 2007,Mac 2011
    Posts
    209

    "Run time error 438, Object doesn't support this property or method."

    Hi all,

    I have a file with macros which is warking all the time. However, when I create a copy of it and rename as needed, I'm getting "Run time error 438, Object doesn't support this property or method."
    But when I press "End" , it continues as ussually.

    When I run it again ( didn't closed the file) , it works without runtime error.

    When I close it, open it again and run the macro, again runtime error. And so on and so on.

    Do you know, why it happenes all time time? I closed all office files, nothing works. Is there a way to prevent it?

    Thanks,
    Andy

  2. #2
    Forum Expert Arkadi's Avatar
    Join Date
    02-13-2014
    Location
    Smiths Falls, Ontario, Canada
    MS-Off Ver
    Excel 2016
    Posts
    4,063

    Re: "Run time error 438, Object doesn't support this property or method."

    Can you upload the file so we can look at the problem?
    Please help by:

    Marking threads as closed once your issue is resolved. How? The Thread Tools at the top
    Any reputation (*) points appreciated. Not just by me, but by all those helping, so if you found someone's input useful, please take a second to click the * at the bottom left to let them know

    There are 10 kinds of people in this world... those who understand binary, and those who don't.

  3. #3
    Forum Contributor
    Join Date
    11-04-2012
    Location
    Czech Republic
    MS-Off Ver
    MS 2007,Mac 2011
    Posts
    209

    Re: "Run time error 438, Object doesn't support this property or method."

    Hi

    sure, no problem.

    See attached.

    Thanks,
    Andy
    Attached Files Attached Files

  4. #4
    Forum Guru Andy Pope's Avatar
    Join Date
    05-10-2004
    Location
    Essex, UK
    MS-Off Ver
    2003, 2007, 2010 & 2013
    Posts
    18,312

    Re: "Run time error 438, Object doesn't support this property or method."

    Your problems all stem from using the Selection object on a sheet that is not active.

    alter your code to reference the object model and not Selection
    Cheers
    Andy
    www.andypope.info

  5. #5
    Forum Contributor
    Join Date
    11-04-2012
    Location
    Czech Republic
    MS-Off Ver
    MS 2007,Mac 2011
    Posts
    209

    Re: "Run time error 438, Object doesn't support this property or method."

    Hi Andy,

    But my macro to create charts starts with wshABI_Mnth_Merge.Activate.
    Could you please help me, how to do this? I'm in the end At least to show me first chart macro, how to do this?

    Thanks,
    Andy

  6. #6
    Forum Expert Arkadi's Avatar
    Join Date
    02-13-2014
    Location
    Smiths Falls, Ontario, Canada
    MS-Off Ver
    Excel 2016
    Posts
    4,063

    Re: "Run time error 438, Object doesn't support this property or method."

    dobracik,

    It seems the Trend Charts sheet needs to be the active sheet to do this. So in your ABI_Monthly macro, you need one extra line.
    After your comment 'Format the created chart, add this line:

    Please Login or Register  to view this content.
    just before this line:
    Please Login or Register  to view this content.

  7. #7
    Forum Contributor
    Join Date
    11-04-2012
    Location
    Czech Republic
    MS-Off Ver
    MS 2007,Mac 2011
    Posts
    209

    Re: "Run time error 438, Object doesn't support this property or method."

    Whoooo, works. I'm so happy. So easy
    thanks a lot for this

    Task solved.

    Andy

  8. #8
    Forum Expert Arkadi's Avatar
    Join Date
    02-13-2014
    Location
    Smiths Falls, Ontario, Canada
    MS-Off Ver
    Excel 2016
    Posts
    4,063

    Re: "Run time error 438, Object doesn't support this property or method."

    You are welcome
    Please mark the thread as solved?

  9. #9
    Forum Guru Andy Pope's Avatar
    Join Date
    05-10-2004
    Location
    Essex, UK
    MS-Off Ver
    2003, 2007, 2010 & 2013
    Posts
    18,312

    Re: "Run time error 438, Object doesn't support this property or method."

    Please Login or Register  to view this content.

  10. #10
    Forum Guru Andy Pope's Avatar
    Join Date
    05-10-2004
    Location
    Essex, UK
    MS-Off Ver
    2003, 2007, 2010 & 2013
    Posts
    18,312

    Re: "Run time error 438, Object doesn't support this property or method."

    if you don't need the other sheet active then just remove the first line

    Please Login or Register  to view this content.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1