View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Jeremiah Jeremiah is offline
external usenet poster
 
Posts: 49
Default Fighting a date format

I need the following to return the value of the cell, not the word "TRUE", I
have tried multiple ways to get this with no luck. Am sure it is an obvious
change.

For Each cell In Range("b:b")
If cell.Value Like "* Totals" Then
cell.Offset(5, 0) = IsDate(Range("C3"))
selection.NumberFormat = "m/d/yyyy"
End If