I may be completely off track but often flickering is caused if you are
selecting cells, sheets etc rather than accessing their values
directly.

If you're not doing that another idea would be try
Application.ScreenUpdating = False (then set it to true when you're
finished)