Hey, can anybody please tell me why you can not pass a cell to a sub
eg
Private Sub Worksheet_Change(ByVal Target As Range)
For Each Cell In Target.Cells
CellChanged (Cell)
Next
End Sub
Private Sub CellChanged (Cell)
if Cell.Column = 2 and Cell.Range = 2 and Cell.Value <> "" then beep
End Sub
Although I can see things like Cell.Column in Worksheet_Change, it appears that it only passes the value to CellChanged, not everything else.
Is there anyway around this