| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Referencing Excel Cells
Hi,
Dim StartDate As Date If Range("F5").Value StartDate Then your code Else your code End If HTH Cheers Carim |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| referencing cells based on conditions in other cells | Excel Discussion (Misc queries) | |||
| Referencing the same cells | Excel Discussion (Misc queries) | |||
| How do I save an Excel workbook so that cells referencing another. | Excel Discussion (Misc queries) | |||
| Referencing cells to VB | Excel Programming | |||
| Referencing Cells in VB | Excel Programming | |||
Linear Mode
