timediff

  1. A

    Timediff with a difference

    <!--[if gte mso 9]><xml> <o:OfficeDocumentSettings> <o:AllowPNG/> </o:OfficeDocumentSettings> </xml><![endif]--><!--[if gte mso 9]><xml> <w:WordDocument> <w:View>Normal</w:View> <w:Zoom>0</w:Zoom> <w:TrackMoves/> <w:TrackFormatting/> <w:PunctuationKerning/>...
  2. C

    TimeDiff Type Mismatch

    If ((DateDiff((Cells(nRow, 7).Value), Date, "d") > 1) & ((DateDiff(Date, (Cells(nRow, 8).Value), "d")) > 1)) Then Sheets("Sheet").Cells(nRow, 33) = "Active" End If When my macro runs through the above code, I get a type mismatch error. All of the cells are formatted at Date only...

Some videos you may like

This Week's Hot Topics

Top