without seeing the macro (or at least the key parts of it) it's hard to guess