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.

    Selection.AutoFill Destination:=Range("S2:S7953")
    Range("S2:S7953").Select
        
    Application.Wait (Now() + TimeValue("00:00:06"))
    SendKeys "{ESCAPE}"
If some can help me, I will be grateful

Waiting for feedback
Regards


press escape.png