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

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

Hmm ok, it works when they are both not in A1. However I have had an
instance where it missed copying the first column. I guess I could just add
into the macro to select A1 in both sheets.



"Norman Jones" wrote:

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