Closed Thread
Results 1 to 4 of 4

Insert UserForm Data in Named Range

  1. #1
    Registered User
    Join Date
    09-28-2008
    Location
    Katy, TX
    Posts
    59

    Insert UserForm Data in Named Range

    I have the following code and would like to have it inserted in to a named range when saved? I got the code below from another thread and it only adds the data to the bottom of my worksheet, but it is not part of the named range!

    Please Login or Register  to view this content.
    Thanks in advance for your help,

    g

  2. #2
    Forum Guru Andy Pope's Avatar
    Join Date
    05-10-2004
    Location
    Essex, UK
    MS-Off Ver
    O365
    Posts
    19,604

    Re: Insert UserForm Data in Named Range

    Does you named range consist of 2 cells or many cells and you want the information add to the next empty part?

    Can you post the name and definition of the named range.
    Cheers
    Andy
    www.andypope.info

  3. #3
    Registered User
    Join Date
    09-28-2008
    Location
    Katy, TX
    Posts
    59

    Re: Insert UserForm Data in Named Range

    Yes, thanks for your help...

    The named range is ForumsPostings and the range is ='Forums Postings'!$A$4:$G$10

    I'm not all that good at excel so I hope this give you what you requested. If not let me know.

    Thanks,

    g

  4. #4
    Forum Moderator Paul's Avatar
    Join Date
    02-05-2007
    Location
    Wisconsin
    MS-Off Ver
    2016/365
    Posts
    6,799

    Re: Insert UserForm Data in Named Range

    This, too, is a cross-post without links.

    http://www.mrexcel.com/forum/showthread.php?t=402917

    Please do not cross-post without links in the future as those threads will be locked.

Closed 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