Makro autom. alle 30 Sek. ausführ.
04.06.2021 16:13:36
Boris
Option Explicit
Sub Makro1()
Range("A1").Copy
Sheets("Tabelle2").Range("A1").Insert Shift:=xlDown
End Sub
Sub Makro2()
Application.OnTime Now + Timevalue("0:00:30"), "Makro1"
Application.Statusbar = Now
End Sub