Hi, I am pretty new to vb and I was wondering if somebody could explai
me how this code works:

Private Sub Worksheet_Change(ByVal Target As Range)
Dim temp As Range
Set temp = Intersect(Target, Range("H3:H16"))
If temp Is Nothing Then
Else
Target.Offset(0, -1) = Target.Offset(0, -1) - Target
End If
End Sub

what does 'Target As Range' mean and how can 'Target' be something i
we dont input anything? Also explain the intersect function please.

Thanks a lot guys. Regards,

Marco

-----------------------------------------------
~~ Message posted from http://www.ExcelTip.com
~~View and post usenet messages directly from http://www.ExcelForum.com