hi,
i am using
i want to add if system date is greater then b1 value then also run now()Dim LValue As String if range c1 = 0 then LValue = Format(Date, "dd-mmm-yyyy") Range("B1") = LValue else end if
like this
thank youDim LValue As String if range c1 = 0 or if date > range b1 then LValue = Format(Date, "dd-mmm-yyyy") Range("B1") = LValue else end if
Bookmarks