$$Excel-Macros$$ Re: macros help needed

2008-12-09 Thread kalpesh velinkar
Dear Shreyas : I am also intrested in the solution. Please forward to me incase you receive any solution. Kind Regards Kalpesh Velinkar On Tue, Dec 9, 2008 at 11:37 AM, Shreyas. Shringarpure wrote: > Following is an excel sheet which contains data abt shares I want to > follow. > > I want to

$$Excel-Macros$$ Re: macros help needed

2008-12-09 Thread Akhilesh Karna
1. In your worksheet module add the following procedure 'if there is change in the Column-H mailPrice module will be called. Private Sub Worksheet_Change(ByVal Target As Range) Dim r As Range Set r = Intersect(Target, Range("H3:H80")) If r Is Nothing Then Exit Sub If r.Rows.Count >