How to avoid sheets select.

[martijnrikkert]

I have a code that picks data from a outlook outlook into excel. I use sheets select in this but with refreshing it getting slow. So I want to avoid sheets select. But I don't how to do this with this code.

See code below

Please Login or Register  to view this content.

[harrisonland]

First of all, I'd switch off Application.ScreenUpdating at the beginning - don't forget to switch back on again afterwards, then see below...

Please Login or Register  to view this content.

Additionally, it's generally not a good idea to use whole columns or rows, as with certain formulae it can really have a speed and resources impact. Try to limit the range that needs processing instead.

Tim