Dear All,
Very Good Morning
I have one Query .
i am looking in Range (A2:E2) . If cell contain yes word then don't
hide otherwise hide the column .
for example
if in A2 Cell word is Yes , i am Fine then A column must be hide
if D2 cell contain Prafull ,Yes is is fine then D column must be hide
Try this !
Sub HideYes()
Dim Rng As Range
For Each Rng In Range(A2:E2)
If InStr(1, LCase(Rng), yes) 0 Then Rng.EntireColumn.Hidden
= True
Next
End Sub
On 07-09-2013 10:46, Prafull Jadhav wrote:
Dear All,
Very Good Morning
I have one Query .
i am looking in Range
@googlegroups.com]
On Behalf Of Prafull Jadhav
Sent: Saturday, September 07, 2013 9:16 AM
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ Macro for Hide Column
Dear All,
Very Good Morning
I have one Query .
i am looking in Range (A2:E2) . If cell contain yes word then don't
hide
Thanks a Lot De Sir.
On Sat, Sep 7, 2013 at 9:59 AM, De Premor d...@premor.net wrote:
Try this !
Sub HideYes()
Dim Rng As Range
For Each Rng In Range(A2:E2)
If InStr(1, LCase(Rng), yes) 0 Then Rng.EntireColumn.Hidden =
True
Next
End Sub
On 07-09-2013 10:46,