Thankyou Berend,

Is it possible to define this macro without specific cell
references? My issue is there are multiple excel rows
where this check needs to occur? I was hoping I could
specify something like:
'If 'AAA' from data validation list is active then set the
specific cells associated with that same row to zero'

Rgds,

Don-
-----Original Message-----
Should have tried that first, before posting. Here is how
it should have
been.....

Private Sub adsf()

If ActiveWorkbook.ActiveSheet.Cells(4, 4).Value = "AAA"
Then
Cells(4, 5).Value = 0
Cells(4, 6).Value = 0
Cells(4, 7).Value = 0
End If

End Sub

I prefer the R1C1 cell values. The A1 values should work
just fine...


---
Message posted from http://www.ExcelForum.com/

.