Re: $$Excel-Macros$$ hide column VBA

thanks Don Pawel As you see I'm not loosing time "everyday something new" thanks to you mate From: dguillett1 To: excel-macros@googlegroups.com Sent: Sunday, September 16, 2012 2:24 PM Subject: Re: $$Excel-Macros$$ hide column VBA or one l

Re: $$Excel-Macros$$ hide column VBA

@googlegroups.com Subject: Re: $$Excel-Macros$$ hide column VBA Sub sample() For i = 1 To ActiveSheet.UsedRange.Columns.Count If Cells(1, i).Value = 1 Then Cells(1, i).EntireColumn.Hidden = True End If Next End Sub On Sun, Sep 16, 2012 at 4:14 PM, pawel lupinski wrote: Hi All, I wonder if you can

Re: $$Excel-Macros$$ hide column VBA

thanks a lot Pawel From: ashish koul To: excel-macros@googlegroups.com Sent: Sunday, September 16, 2012 11:48 AM Subject: Re: $$Excel-Macros$$ hide column VBA Sub sample() For i = 1 To ActiveSheet.UsedRange.Columns.Count If Cells(1, i).Value = 1 Then

Re: $$Excel-Macros$$ hide column VBA

Sub sample() For i = 1 To ActiveSheet.UsedRange.Columns.Count If Cells(1, i).Value = 1 Then Cells(1, i).EntireColumn.Hidden = True End If Next End Sub On Sun, Sep 16, 2012 at 4:14 PM, pawel lupinski wrote: > Hi All, > > I wonder if you can help me, I'd like to hide all columns if the value