Your best bet is to look through the macro and figure out what it does and what part of it does what you need. If that macro is too big to track, start with some of the smaller macros to get the basic fundamentals of the macro language, then move on to the harder stuff.