Referencing Excel Cells
 

Hi Guys
Very new to VBA - can anyone help?
I need to reference a value (which might change) in cell F5 in some VBA
code.
For example I need to say . .. If (the value of F5) is StartDate Then
....
Thanks
MarkvdH

Referencing Excel Cells
 

Hi,

Dim StartDate As Date

If Range("F5").Value StartDate Then
your code
Else
your code
End If

HTH
Cheers
Carim

Referencing Excel Cells
 

Hi Carim
Thanks for your help
MarkvdH


Carim wrote:
Hi,

Dim StartDate As Date

If Range("F5").Value StartDate Then
your code
Else
your code
End If

HTH
Cheers
Carim