could someone please add a code for me, i am new at excel

[daniboymu]

Hi Guys, I need some help, could someone please add a code which makes this macro runs every 15 minutes also if possible makes the macro runs only between 9:15 am to 6:15 pm the second ask its only if possible. thanks anyway!!
THE CODE:

Sub Atualizar()

    Rows(7).Insert
   Range("A8:DG8").Value = Range("A5:DG5").Value
End Sub

 

[JB2020]

You could do something like this.

Sub Atualizar()

    Do
        If Time < TimeValue("09:15:00") Or Time >= TimeValue("18:15:00") Then End
        Rows(7).Insert
        Range("A8:DG8").Value = Range("A5:DG5").Value
        Application.Wait (Now + TimeValue("0:15:00"))
    Loop
    
End Sub

 

[daniboymu]

tomorrow I'll check if its worked, probaly it will be, so thank you very much!!

 

[daniboymu]

You could do something like this.

Sub Atualizar()

    Do
        If Time < TimeValue("09:15:00") Or Time >= TimeValue("18:15:00") Then End
        Rows(7).Insert
        Range("A8:DG8").Value = Range("A5:DG5").Value
        Application.Wait (Now + TimeValue("0:15:00"))
    Loop
   
End Sub

i tried here buy my excel just stop working

 

[daniboymu]

So, when I run the macro i Cant use the sheet anymore, why is this happening?

 

[JB2020]

That works by running a macro on a continuous loop and waiting 15 minutes at the end of each loop. There isn't really an easy way to initiate a macro to run every 15 minutes. You might be able to set something up in Windows task scheduler, however you would probably be better off looking for a different way of doing your process in my opinion.