Thanks a Lot De Sir.
On Sat, Sep 7, 2013 at 9:59 AM, De Premor 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,
[mailto:excel-macros@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
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 (
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 mus
