Re: $$Excel-Macros$$ Need looping to hide row

Thank you very much...Cheers!! Regards. Ashish Bhalara 9624111822 P*Please do not print this email unless it is absolutely necessary. Spread environmental üawareness.♣♣♣* On Tue, Dec 30, 2014 at 12:26 PM, Vaibhav Joshi v...@vabs.in wrote: check this i m not getting any error.. + *I

Re: $$Excel-Macros$$ Need looping to hide row

Hi Try this: Private Sub Worksheet_Change(ByVal Target As Range) Dim rng As Range, c As Range If Target.Cells.Count 1 Or IsEmpty(Target) Then Exit Sub If Not Intersect(Target, Range(A16:A50)) Is Nothing Then Set rng = Range(A16:A150) For Each c In rng If c.Value = Then

Re: $$Excel-Macros$$ Need looping to hide row

Hi Vaibhavji, The Syntex error occur in IF formula. Regards. Ashish Bhalara 9624111822 P*Please do not print this email unless it is absolutely necessary. Spread environmental üawareness.♣♣♣* On Mon, Dec 29, 2014 at 7:07 PM, Vaibhav Joshi v...@vabs.in wrote: Hi Try this: Private Sub

Re: $$Excel-Macros$$ Need looping to hide row

I was wrong, error occur of 'Sub of Function not defined. Regards. Ashish Bhalara 9624111822 P*Please do not print this email unless it is absolutely necessary. Spread environmental üawareness.♣♣♣* On Tue, Dec 30, 2014 at 10:24 AM, Ashish Bhalara ashishbhalar...@gmail.com wrote: Hi Vaibhavji,

Re: $$Excel-Macros$$ Need looping to hide row

check this i m not getting any error.. + *I did not do this for you. God is here working through me for you.* On Tue, Dec 30, 2014 at 10:29 AM, Ashish Bhalara ashishbhalar...@gmail.com wrote: I was wrong, error occur of 'Sub of Function not defined. Regards. Ashish Bhalara 9624111822