+ Reply to Thread
Results 1 to 1 of 1

running a macro then an error of #REF! issue

  1. #1
    Forum Contributor
    Join Date
    10-13-2011
    Location
    Australia
    MS-Off Ver
    Office 16
    Posts
    329

    running a macro then an error of #REF! issue

    Re: the attached file - The file I have contains links into other sheets, most of the data is obtained from the GOIT907 sheet which I paste raw data into. When I run a macro over the raw data to clean it up, all the references in the other sheets show the above #REF! error in all cells – in particular the result data sheet. Is there a way to stop the referencing picking up the changes until after the macro is run?
    Does it have something to do with the Automatic Formulas updating function? When I run the macro, it only wants to work properly when “Automatic “ is selected. The macro is in the file and called Business_907Clean if it needs to be modified in any way?
    The only solutions I have found so far are to: copy and paste the original formulas back into the main sheet after running the macro (I have to then globally remove the sheet/file reference, which restores the outcomes), or I can run the macro over the raw data in another sheet then copy and paste the outcome over the top of the manipulated raw data.
    Attached Files Attached Files

+ 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