If statement to stop Macro

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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?
 
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.
 
Back
Top