RE: $$Excel-Macros$$ there are two code , please explain this code.

2011-07-15 Thread Daniel
nd If End Sub Regards. Daniel De : excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] De la part de neil johnson Envoyé : vendredi 15 juillet 2011 13:50 À : excel-macros; Dave Bonallack; Dilip Pandey Objet : $$Excel-Macros$$ there are two code , please explain this c

$$Excel-Macros$$ there are two code , please explain this code.

2011-07-15 Thread neil johnson
Hi, I need your help . I have query in VBA. Please help me . Private Sub Worksheet_Change(ByVal Target As Range) If Target.Row = 3 And Target.Column = 3 Then 'calculate criteria cell in case calculation mode is manual Worksheets("ProductsList").Range("I3").Calculate Worksheets("ProductsList").Range