Macro vs Function in C

I’m programming in C.

I always saw examples and cases where using a macro is better than using function.

Could someone explain me with an example the disadvantage of a macro compared to a function?