If statement to stop Macro
 

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

If statement to stop Macro
 

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

If statement to stop Macro
 

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