macro if statements
How do I ask: if selection.value = the value in the cell offset (0,-4)??????
"Miguel Zapico" wrote:
This is one option:
If Selection.Value = ActiveSheet.Range("A1").Value Then
It compares the value on the selected cell with the range A1 of the same
worksheet.
Hope this helps,
Miguel.
"Donna S" wrote:
I'm trying to write a simple if statement that looks at an active cell and
compares is to the data in another cell. So far I have:
If Selection.Value = ??????? Then
Please help me fill in the ???????. This is probably very simple but I'm
just learning.
Thanks,
|