How do create a macro to
run every 1 minute to check if cell A1 = "Y".

If A1 = "Y" run macro XXX and exit macro.
If A1 not equal Y, reset to run next 1 min.

I think Do Loop with

Exit Sub

any one?