Results 1 to 5 of 5

Macro not performing correctly

Threaded View

  1. #3
    Registered User
    Join Date
    08-15-2007
    Posts
    3
    Good morning, Robert - thank you for your reply. I apologize for not "unprotecting" the results tabs. I have done so now. I'm still confused, however. I was trying a couple different things this morning and have saved the spreadsheet with a few changes. When I got rid of the data the first time, I used Clear Contents. That would also clear the data out of the Results tab. This time, I used Delete, and when I went to the Results tab, I got the "REF!" message, indicating the macro didn't not have any data to work with. Then, when I pasted the data back in, the Results tab automatically updated - it added data below the "REF!" lines. I was under the impression that the Results tab should never "update itself" - without running the macro. In fact, that is how it works in other copies of this spreadsheet. I've got four other people using a copy of the spreadsheet, and none of them are having this problem. I just don't get it.

    Anyway, I have unprotected the Results worksheets. I would really be appreciative if you would take another look.

    Thanks so much!

    Julie
    Attached Files Attached Files

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