+ Reply to Thread
Results 1 to 4 of 4

Help with Named Ranges and VBA

  1. #1
    Registered User
    Join Date
    02-03-2013
    Location
    Canada
    MS-Off Ver
    Office 365 MSO (16.0.13127.21734) 64-bit
    Posts
    23

    Help with Named Ranges and VBA

    I have a workbook, that several people are entering data in on a daily basis. They enter data on a worksheet, hit a macro enabled button and it saves the data on a separate hidden worksheet. I have another worksheet that totals scores, but when the data stored in the data sheet, the named range changes as rows are inserted. I have a line in my macro that changes the reference back every time the macro runs. It worked great until this year. I saved the file as a new name....deleted old data, everything works fine except it doesn't change my references back anymore. If I had created this workbook, I would have done things a bit different.....but anyway.......

    There are no external connections, the named range is in the current workbook, when the code runs it does not stop, but it does not change the reference. Any thoughts?

    Please Login or Register  to view this content.

  2. #2
    Forum Guru TMS's Avatar
    Join Date
    07-15-2010
    Location
    The Great City of Manchester, NW England ;-)
    MS-Off Ver
    MSO 2007,2010,365
    Posts
    37,222

    Re: Help with Named Ranges and VBA

    Please Login or Register  to view this content.

    Regards, TMS

  3. #3
    Registered User
    Join Date
    02-03-2013
    Location
    Canada
    MS-Off Ver
    Office 365 MSO (16.0.13127.21734) 64-bit
    Posts
    23

    Re: Help with Named Ranges and VBA

    That Worked.....Thank you very much.

  4. #4
    Forum Guru TMS's Avatar
    Join Date
    07-15-2010
    Location
    The Great City of Manchester, NW England ;-)
    MS-Off Ver
    MSO 2007,2010,365
    Posts
    37,222

    Re: Help with Named Ranges and VBA

    You're welcome.

+ 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. Define only 2 named ranges from a list of named ranges...
    By abhi900 in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 04-29-2014, 04:20 AM
  2. Looping Mutliple Named Resized Ranges in next empty row below another named range
    By gingumdog in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 03-19-2014, 08:15 PM
  3. [SOLVED] Determining if the value of a cell can be a named range, then assigning named ranges after
    By Romulo in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 09-15-2013, 06:05 PM
  4. Copy data in named ranges to a newer version of the same template to identical ranges
    By handstand in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 08-21-2006, 10:51 AM
  5. [SOLVED] Named ranges-is there a an easy way to reference a single value in a named range?
    By pspkim@gmail.com in forum Excel General
    Replies: 1
    Last Post: 03-21-2006, 06:40 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