+ Reply to Thread
Results 1 to 2 of 2

Runtime error .. 20028018: Method value of object range failed

  1. #1
    Registered User
    Join Date
    07-14-2010
    Location
    sweden
    MS-Off Ver
    Excel 2003
    Posts
    14

    Runtime error .. 20028018: Method value of object range failed

    Im trying to debug code i havent wrote myself:

    A range is set to something that the program seemes to find. When watching the range.value it returns the correct value.

    The program is using commandbars and commandbarpopups which im not known to at all.

    Please Login or Register  to view this content.
    cmbMenu is a commandbarpopup and rngmenu a range.
    rngmenu.value returns "&mallmeny"

    Runtime error .. 20028018: Method value of object range failed

  2. #2
    Forum Expert pike's Avatar
    Join Date
    12-11-2005
    Location
    Alstonville, Australia
    MS-Off Ver
    2016
    Posts
    5,342

    Re: Runtime error .. 20028018: Method value of object range failed

    Hi petca059,
    The snipet of code is sound what is the complete code?
    If the solution helped please donate to RSPCA

    Site worth visiting: Rabbitohs

+ 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