IT WORKS ...
Private Sub Worksheet_SelectionChange(ByVal Target As Range)
If WorksheetFunction.CountIf(Range("A3:G3"), "XYZ") > 0 Then
Rows("25:30").Hidden = False
End If
End Sub
THANKS FOR SHARING
On Saturday, 2 April 2016 11:21:18 UTC-7, NIJ wrote:
>
> Thanks alot.
Thanks alot.
one more query
IF I WANT TO UNHIDE CERTAIN ROWS SAY ROW 25 TO 30 ( ALREADY HIDDEN) IF
TEXT CONTAIN "XYZ" IN ANY OF CELL A3 TO G3, PLEASE GIVE MACRO FOR THAT.
On Saturday, 2 April 2016 06:53:26 UTC-7, Sam Mathai Chacko wrote:
>
>
> Private Sub Worksheet_SelectionChange(ByVal Target
On Saturday, 2 April 2016 06:30:27 UTC-7, NIJ wrote:
>
> I want to aply below macro to cells A1 to G1 AND A2 TO G2. IS IT
> POSSIBLE THAT IT CAN BE DONE SIMPLY INSTEAD WRITING BELOW MACRO FOR EACH
> CELL VALUE.
>
> Private Sub Worksheet_SelectionChange(ByVal Target As Range)
>
> I
Private Sub Worksheet_SelectionChange(ByVal Target As Range)
Rows("12:18").Hidden =
Worksheetfunction.countif(Range("A1:G2"),"ABC") > 0
End Sub
On Apr 2, 2016 19:18, "NIJ" wrote:
>
>
> On Saturday, 2 April 2016 06:30:27 UTC-7, NIJ wrote:
>>
>> I want to aply below macro to cells A1 to
On Saturday, 2 April 2016 06:30:27 UTC-7, NIJ wrote:
>
> I want to aply below macro to cells A1 to G1 AND A2 TO G2. IS IT
> POSSIBLE THAT IT CAN BE DONE SIMPLY INSTEAD WRITING BELOW MACRO FOR EACH
> CELL VALUE.
>
> Private Sub Worksheet_SelectionChange(ByVal Target As Range)
>
> I
