When we see your code we could give specific advice, however general causes of
slow macros are:

Using the selection object rather than a range object
Not turning screen updating off
Not turning calculation off.