speed up macro VBA

[Bob Phillips]

'... speed up macro
	Application.ScreenUpdating = False
	Application.Calculation = xlCalculationManual

other that the above two lines of code, what can i use to speed up my macro?

Many things, but it is not hard and fast. You can
- remove all selections in your code, and reference via the object,
- look at all your loops and see if it could be done another way
- etc.
and then it is down to the design, seeing if the design is best suited to the task, or whether another approach might be more optimal (for instance, maybe use more Excel built-in functionality.