Hi All,

I am new to VBA I have built a macro to capture data from one sheet to another.

Can someone please help me fix this code I want the macro to start at 7am and run every 15 min after that till 6pm and then close the work book.

Really appreciate any help thank you

The code that I have is

Sub Macro2()

Dim BlankRow As Long

Sheets("DATA").Select
Range("E2:E5").Select
Selection.Copy

Sheets("EWFM").Select
BlankRow = Range("E65536").End(xlUp).Row + 1
Cells(BlankRow, 5).Select
ActiveSheet.PasteSpecial xlPasteValuesAndNumberFormats

Application.OnTime Now + TimeValue("00:15:00"), "Macro2"


End Sub