+ Reply to Thread
Results 1 to 8 of 8

Run-time error '5941': The requested member of the collection does not exist

  1. #1
    Forum Contributor
    Join Date
    01-08-2021
    Location
    Asia
    MS-Off Ver
    2016
    Posts
    292

    Run-time error '5941': The requested member of the collection does not exist

    hello
    I try export specific range in specific sheet to word I rename the sheet to sheet1 and the range rename table1 from a1 : d5 but when run the macro it gives me error The requested member of the collection does not exist in this line
    HTML Code: 
    what means and how fix it ,please?
    HTML Code: 
    Attached Files Attached Files

  2. #2
    Forum Expert rorya's Avatar
    Join Date
    08-13-2008
    Location
    East Sussex, UK
    MS-Off Ver
    365 Ent Monthly Channel / Insiders Beta
    Posts
    8,913

    Re: Run-time error '5941': The requested member of the collection does not exist

    I believe it means there isn't a bookmark called Report in that document.
    Rory

  3. #3
    Forum Contributor
    Join Date
    01-08-2021
    Location
    Asia
    MS-Off Ver
    2016
    Posts
    292

    Re: Run-time error '5941': The requested member of the collection does not exist

    actually I got it from web Microsoft I don't understand bookmark what means it and how change it ?

  4. #4
    Forum Expert rorya's Avatar
    Join Date
    08-13-2008
    Location
    East Sussex, UK
    MS-Off Ver
    365 Ent Monthly Channel / Insiders Beta
    Posts
    8,913

    Re: Run-time error '5941': The requested member of the collection does not exist

    A bookmark is a specially designated section in a Word document.

  5. #5
    Forum Contributor
    Join Date
    01-08-2021
    Location
    Asia
    MS-Off Ver
    2016
    Posts
    292

    Re: Run-time error '5941': The requested member of the collection does not exist

    do I check it in reference or what?

  6. #6
    Forum Guru Norie's Avatar
    Join Date
    02-02-2005
    Location
    Stirling, Scotland
    MS-Off Ver
    Microsoft Office 365
    Posts
    19,643

    Re: Run-time error '5941': The requested member of the collection does not exist

    Posted in wrong thread.
    If posting code please use code tags, see here.

  7. #7
    Forum Expert rorya's Avatar
    Join Date
    08-13-2008
    Location
    East Sussex, UK
    MS-Off Ver
    365 Ent Monthly Channel / Insiders Beta
    Posts
    8,913

    Re: Run-time error '5941': The requested member of the collection does not exist

    You need to set it up in your Word document using Insert - Bookmark.

  8. #8
    Forum Contributor
    Join Date
    01-08-2021
    Location
    Asia
    MS-Off Ver
    2016
    Posts
    292

    Re: Run-time error '5941': The requested member of the collection does not exist

    @rorya thanks so much now it works

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Getting error User input data error. Sheet name requested does not exist.
    By mso3 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 11-30-2016, 08:32 AM
  2. Replies: 0
    Last Post: 12-08-2014, 06:46 AM
  3. [SOLVED] Error 5941 when running macro in MS Word
    By jen1220 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 11-20-2014, 07:16 PM
  4. Replies: 22
    Last Post: 05-14-2014, 07:27 AM
  5. [SOLVED] Run Time Error 3265 - Item not found in this collection
    By Sc0tt1e in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 12-23-2013, 07:19 AM
  6. [SOLVED] Run time error 13 with new Collection
    By Tomkat743 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 04-19-2006, 07:50 AM
  7. [SOLVED] Run time error 5941
    By Ramon Nunez via OfficeKB.com in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 01-11-2005, 10:06 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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1