Hi Ernest,

Why not instead write your macro to be independent of the active cell
location?

---
Regards,
Norman



"Ernest Lai" wrote in message
...
Hi all, I have a macro which basically rearranges data ready for another
person to upload. I want to create a fail safe for it. Can I make a
macro
to do, If the cursor is not in A1 field on both sheets not to run, and
print
an error msg? I imagine it will be something like:

If cursor A1 on Sheet A And A1 on Sheet B
Then run macro <name
Else "print error, cursor not in A1 positions on sheet A / B" And End
macro.

Thanks in advance, and any help is much appretiated

Ernest