Putting a time limit on a macro.

[bloodmilksky]

Hi Guys,

Does anyone know if you stop a macro running if it is within 48hrs of a date specified in range a1(from) a2 (To) Sheet 1.

many thanks

Jamie

 

[oldbrewer]

assume in your macro the date is called mydate

if mydate>=cells(1,1) and mydate<=cells(2,1) then goto 100

100 is end sub