Good morning everyone.

I would like to kindly ask you if someone can help me with my code.
I want to create a VBA where I will have to use an auto fill to complete all cells with one formula.
This formula is a vlookup, from an external document.

Once I run the vba with the auto fill I have to wait too much time or to press cancel for excel fills cells.

So I was wondering if instead of pressing "ESC" myself, it is possible to do it thru VBA.
I tried already function wait and sendkeys but nothing happened.

Please Login or Register  to view this content.
If some can help me, I will be grateful

Waiting for feedback
Regards


press escape.png