UBS interview question

Explain how macros on excel work