I also get confused. I know that macro photography is close-up photography. But then, what is micro photography. And in other instances of the word "macro" -- macro-economics, for instance -- macro means a wide, distant view of things. Ah well, the English language is just like that, I guess.
As Porky Pig would say, "Tha...tha...tha...tha...that's all, folks!"