Re: $$Excel-Macros$$ Re: Want to hide entire row

2011-12-04 Thread Abdulgani Shaikh
ls(i, "L") >= 0 Then _ >>>> Rows(i).Hidden = True >>>> Next >>>> Application.ScreenUpdating = True >>>> End Sub >>>> >>>> Sub UnhideRows() >>>> Rows.Hidden = False >>>> End Sub >>

Re: $$Excel-Macros$$ Re: Want to hide entire row

2011-12-04 Thread Sam Mathai Chacko
True >>> Next >>> Application.ScreenUpdating = True >>> End Sub >>> >>> Sub UnhideRows() >>> Rows.Hidden = False >>> End Sub >>> ‘ >>> Don Guillett >>> SalesAid Software >>> dguille...@gmail.co

Re: $$Excel-Macros$$ Re: Want to hide entire row

2011-12-04 Thread AbdulGani Shaikh
gt; End Sub >> ‘ >> Don Guillett >> SalesAid Software >> dguille...@gmail.com >> >> *From:* AbdulGani Shaikh >> *Sent:* Thursday, December 01, 2011 9:45 PM >> *To:* excel-macros@googlegroups.com >> *Subject:* $$Excel-Macros$$ Re:

Re: $$Excel-Macros$$ Re: Want to hide entire row

2011-12-04 Thread AbdulGani Shaikh
rue > End Sub > > Sub UnhideRows() > Rows.Hidden = False > End Sub > ‘ > Don Guillett > SalesAid Software > dguille...@gmail.com > > *From:* AbdulGani Shaikh > *Sent:* Thursday, December 01, 2011 9:45 PM > *To:* excel-macros@googlegroups.com > *Subje

Re: $$Excel-Macros$$ Re: Want to hide entire row

2011-12-02 Thread Sam Mathai Chacko
rue > End Sub > > Sub UnhideRows() > Rows.Hidden = False > End Sub > ‘ > Don Guillett > SalesAid Software > dguille...@gmail.com > > *From:* AbdulGani Shaikh > *Sent:* Thursday, December 01, 2011 9:45 PM > *To:* excel-macros@googlegroups.com > *Subject:* $

Re: $$Excel-Macros$$ Re: Want to hide entire row

2011-12-02 Thread dguillett1
True Next Application.ScreenUpdating = True End Sub Sub UnhideRows() Rows.Hidden = False End Sub ‘ Don Guillett SalesAid Software dguille...@gmail.com From: AbdulGani Shaikh Sent: Thursday, December 01, 2011 9:45 PM To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ Re: Want

Re: $$Excel-Macros$$ Re: Want to hide entire row

2011-12-02 Thread ashish koul
do you want to hide rows with error value or not On Fri, Dec 2, 2011 at 4:40 PM, AbdulGani Shaikh wrote: > It gives error, screenshot of which is attached herewith > Regards > > On Fri, Dec 2, 2011 at 12:20 PM, ashish koul wrote: > >> Sub hide_data() >> Application.ScreenUpdating = False >> App

Re: $$Excel-Macros$$ Re: Want to hide entire row

2011-12-01 Thread ashish koul
Sub hide_data() Application.ScreenUpdating = False Application.DisplayAlerts = False Dim i As Long For i = Sheets(1).Range("a1").SpecialCells(xlLastCell).Row To 2 Step -1 If Sheets(1).Range("I" & i).Value >= 0 Or Sheets(1).Range("l" & i).Value >= 0 Then Sheets(1).Rows(i & ":" & i).Hidden = True En

$$Excel-Macros$$ Re: Want to hide entire row

2011-12-01 Thread AbdulGani Shaikh
Pl.help On Thu, Dec 1, 2011 at 4:41 PM, Abdulgani Shaikh < abdulgani.sha...@sarda.co.in> wrote: > I want to hide entire row if value in column "*I*" & column "*L*" is > greater than or equal to "*0*". > In other words if value in column i & l is less than zero then only such > row to be shown oth