View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
loren.pottinger loren.pottinger is offline
external usenet poster
 
Posts: 34
Default Using DateAdd function with cell values.

Both F7 and H7 contain a date yet this sub does not execute the
statements after Then.................Please help.

Sub GetAmOrDep()

Dim TestDate As Date
TestDate = DateAdd("m", Range("F7").Value, Range("H7").Value)

If TestDate < Range("I7").Value Then
Range("K7").Select
Selection.Copy
Range("M7").Select
ActiveSheet.Paste
End If
End Sub