Thread: Changing Date Values to a working Integer
View Single Post
  #1  
Old 06-30-2009, 04:21 PM
bdb1974 bdb1974 is offline
Valued Forum Contributor
  
Join Date: 10 Dec 2008
Location: Austin
Posts: 414
bdb1974 is becoming part of the community
Changing Date Values to a working Integer
Hello,

I need help in making this a true working statement.
Code as is errors for "object doesn't support this property or method"

Code:
If OutIY.Cells(i, "D") <> OutIY.Cells(i, "F") And WorksheetFunction.Int(Cells(i, "G").Value = WorksheetFunction.Int(today).Value) Then Cells(findit.Row, "G") = (Format(Now, "mm/dd/yyyy"))
where "G" = 06/30/2009 (or any other date)
Thanks again and always,

BDB
Last edited by bdb1974; 06-30-2009 at 04:28 PM.
Reply With Quote