Will not be able to comment unless you provide more information as to what the macro is, and what the data is etc. Posting a trimmed down version of the file with an exact representation of the scenario might help.