View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Kelzina Kelzina is offline
external usenet poster
 
Posts: 12
Default code to input date after diff. cell selected

basically i want to insert a date in to one cell but only if i select another
cell... make sense??? i attempted the following but had no result considering
the Range("D3").... selects the cell... can anyone help
Sub Insert_Date()

If Range("D2").Select Then
cell = ("L4") = ""
Else
cell = ("L4") = "=TODAY()"
End If

End Sub
--
"The difference between Possible and Impossible is the measure of ones will"