Re: $$Excel-Macros$$ Re: SAME MACRO FOR MANY CELLS

[NIJ]

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.
> 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 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 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)

   If Range("A1").Value = "ABC" Then
 Rows("12:18").Hidden = True
 
 End If
 
 End Sub

>>>
>>> I WANT ANY OF CELL FROM A1 TO G2 IF CONTAIN "ABC" VALUE ROWS GET HIDE.
>>>
>>> THANKS FOR RESPONSE
>>>
>>> I 
>>>
>>> -- 
>>> Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? 
>>> It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ 
>>> https://www.facebook.com/discussexcel
>>>  
>>> FORUM RULES
>>>  
>>> 1) Use concise, accurate thread titles. Poor thread titles, like Please 
>>> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice 
>>> will not get quick attention or may not be answered.
>>> 2) Don't post a question in the thread of another member.
>>> 3) Don't post questions regarding breaking or bypassing any security 
>>> measure.
>>> 4) Acknowledge the responses you receive, good or bad.
>>> 5) Jobs posting is not allowed.
>>> 6) Sharing copyrighted material and their links is not allowed.
>>>  
>>> NOTE : Don't ever post confidential data in a workbook. Forum owners and 
>>> members are not responsible for any loss.
>>> --- 
>>> You received this message because you are subscribed to the Google 
>>> Groups "MS EXCEL AND VBA MACROS" group.
>>> To unsubscribe from this group and stop receiving emails from it, send 
>>> an email to excel-macros...@googlegroups.com.
>>> To post to this group, send email to excel-...@googlegroups.com.
>>> Visit this group at https://groups.google.com/group/excel-macros.
>>> For more options, visit https://groups.google.com/d/optout.
>>>
>>

-- 
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s 
=TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ 
https://www.facebook.com/discussexcel

FORUM RULES

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.
2) Don't post a question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any security measure.
4) Acknowledge the responses you receive, good or bad.
5) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.

NOTE  : Don't ever post confidential data in a workbook. Forum owners and 
members are not responsible for any loss.
--- 
You received this message because you are subscribed to the Google Groups "MS 
EXCEL AND VBA MACROS" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to excel-macros+unsubscr...@googlegroups.com.
To post to this group, send email to excel-macros@googlegroups.com.
Visit this group at https://groups.google.com/group/excel-macros.
For more options, visit https://groups.google.com/d/optout.

Re: $$Excel-Macros$$ Comine Text

[vickey]

Dear Mr. Pankaj,

Thanks,

Just in addition to this can you send me revised code attached file.

Thanks in advance




On Sunday, April 3, 2016 at 5:40:52 AM UTC+5:30, Pankaj Sharma wrote:
>
> chk
>
>   
>   
> *PJ  *
>
> *MIS Analyst*
> 
>
> *Greater Kailash-1, New Delhi.*
>
> *Instagram*  *pj_sharma_*
>
> *Tweeter*   
> *dude_sharma_pj**Facebook**   www.facebook.com/dude.pj 
> *
>
>   
> *We meet for a reason, either you're a blessing or a lesson...*
>
> On Sat, Apr 2, 2016 at 11:20 PM, vickey  
> wrote:
>
>>
>>
>> Hi,
>>
>> Please help me out to solve this problem, I have following table. Now 
>> what I want to have result as third column "Combine". 
>>
>> Srn Name Combine 
>> 1 A A, B, C 
>> B 
>> C 
>> 2 D D, E 
>> E 
>> 3 F F, G, H, I, J 
>> G 
>> H 
>> I 
>> J 
>> 4 K K 
>> 5 O O, P 
>> P 
>>
>> -- 
>> Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s 
>> =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ 
>> https://www.facebook.com/discussexcel
>>  
>> FORUM RULES
>>  
>> 1) Use concise, accurate thread titles. Poor thread titles, like Please 
>> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice 
>> will not get quick attention or may not be answered.
>> 2) Don't post a question in the thread of another member.
>> 3) Don't post questions regarding breaking or bypassing any security 
>> measure.
>> 4) Acknowledge the responses you receive, good or bad.
>> 5) Jobs posting is not allowed.
>> 6) Sharing copyrighted material and their links is not allowed.
>>  
>> NOTE : Don't ever post confidential data in a workbook. Forum owners and 
>> members are not responsible for any loss.
>> --- 
>> You received this message because you are subscribed to the Google Groups 
>> "MS EXCEL AND VBA MACROS" group.
>> To unsubscribe from this group and stop receiving emails from it, send an 
>> email to excel-macros...@googlegroups.com .
>> To post to this group, send email to excel-...@googlegroups.com 
>> .
>> Visit this group at https://groups.google.com/group/excel-macros.
>> For more options, visit https://groups.google.com/d/optout.
>>
>
>

-- 
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s 
=TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ 
https://www.facebook.com/discussexcel

FORUM RULES

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.
2) Don't post a question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any security measure.
4) Acknowledge the responses you receive, good or bad.
5) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.

NOTE  : Don't ever post confidential data in a workbook. Forum owners and 
members are not responsible for any loss.
--- 
You received this message because you are subscribed to the Google Groups "MS 
EXCEL AND VBA MACROS" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to excel-macros+unsubscr...@googlegroups.com.
To post to this group, send email to excel-macros@googlegroups.com.
Visit this group at https://groups.google.com/group/excel-macros.
For more options, visit https://groups.google.com/d/optout.


problem data combine.xlsx
Description: MS-Excel 2007 spreadsheet

Re: $$Excel-Macros$$ Comine Text

[Pankaj Sharma]

chk



*PJ  *

*MIS Analyst*


*Greater Kailash-1, New Delhi.*

*Instagram*  *pj_sharma_*

*Tweeter*
*dude_sharma_pj**Facebook**   www.facebook.com/dude.pj
*


*We meet for a reason, either you're a blessing or a lesson...*

On Sat, Apr 2, 2016 at 11:20 PM, vickey  wrote:

>
>
> Hi,
>
> Please help me out to solve this problem, I have following table. Now what
> I want to have result as third column "Combine".
>
> Srn Name Combine
> 1 A A, B, C
> B
> C
> 2 D D, E
> E
> 3 F F, G, H, I, J
> G
> H
> I
> J
> 4 K K
> 5 O O, P
> P
>
> --
> Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
> =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
> https://www.facebook.com/discussexcel
>
> FORUM RULES
>
> 1) Use concise, accurate thread titles. Poor thread titles, like Please
> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
> will not get quick attention or may not be answered.
> 2) Don't post a question in the thread of another member.
> 3) Don't post questions regarding breaking or bypassing any security
> measure.
> 4) Acknowledge the responses you receive, good or bad.
> 5) Jobs posting is not allowed.
> 6) Sharing copyrighted material and their links is not allowed.
>
> NOTE : Don't ever post confidential data in a workbook. Forum owners and
> members are not responsible for any loss.
> ---
> You received this message because you are subscribed to the Google Groups
> "MS EXCEL AND VBA MACROS" group.
> To unsubscribe from this group and stop receiving emails from it, send an
> email to excel-macros+unsubscr...@googlegroups.com.
> To post to this group, send email to excel-macros@googlegroups.com.
> Visit this group at https://groups.google.com/group/excel-macros.
> For more options, visit https://groups.google.com/d/optout.
>

-- 
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s 
=TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ 
https://www.facebook.com/discussexcel

FORUM RULES

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.
2) Don't post a question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any security measure.
4) Acknowledge the responses you receive, good or bad.
5) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.

NOTE  : Don't ever post confidential data in a workbook. Forum owners and 
members are not responsible for any loss.
--- 
You received this message because you are subscribed to the Google Groups "MS 
EXCEL AND VBA MACROS" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to excel-macros+unsubscr...@googlegroups.com.
To post to this group, send email to excel-macros@googlegroups.com.
Visit this group at https://groups.google.com/group/excel-macros.
For more options, visit https://groups.google.com/d/optout.


Combine.xls
Description: MS-Excel spreadsheet

Re: $$Excel-Macros$$ Re: SAME MACRO FOR MANY CELLS

[NIJ]

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 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 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)
>>>
>>>   If Range("A1").Value = "ABC" Then
>>> Rows("12:18").Hidden = True
>>> 
>>> End If
>>> 
>>> End Sub
>>>
>>
>> I WANT ANY OF CELL FROM A1 TO G2 IF CONTAIN "ABC" VALUE ROWS GET HIDE.
>>
>> THANKS FOR RESPONSE
>>
>> I 
>>
>> -- 
>> Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s 
>> =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ 
>> https://www.facebook.com/discussexcel
>>  
>> FORUM RULES
>>  
>> 1) Use concise, accurate thread titles. Poor thread titles, like Please 
>> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice 
>> will not get quick attention or may not be answered.
>> 2) Don't post a question in the thread of another member.
>> 3) Don't post questions regarding breaking or bypassing any security 
>> measure.
>> 4) Acknowledge the responses you receive, good or bad.
>> 5) Jobs posting is not allowed.
>> 6) Sharing copyrighted material and their links is not allowed.
>>  
>> NOTE : Don't ever post confidential data in a workbook. Forum owners and 
>> members are not responsible for any loss.
>> --- 
>> You received this message because you are subscribed to the Google Groups 
>> "MS EXCEL AND VBA MACROS" group.
>> To unsubscribe from this group and stop receiving emails from it, send an 
>> email to excel-macros...@googlegroups.com .
>> To post to this group, send email to excel-...@googlegroups.com 
>> .
>> Visit this group at https://groups.google.com/group/excel-macros.
>> For more options, visit https://groups.google.com/d/optout.
>>
>

-- 
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s 
=TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ 
https://www.facebook.com/discussexcel

FORUM RULES

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.
2) Don't post a question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any security measure.
4) Acknowledge the responses you receive, good or bad.
5) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.

NOTE  : Don't ever post confidential data in a workbook. Forum owners and 
members are not responsible for any loss.
--- 
You received this message because you are subscribed to the Google Groups "MS 
EXCEL AND VBA MACROS" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to excel-macros+unsubscr...@googlegroups.com.
To post to this group, send email to excel-macros@googlegroups.com.
Visit this group at https://groups.google.com/group/excel-macros.
For more options, visit https://groups.google.com/d/optout.

$$Excel-Macros$$ Comine Text

[vickey]

Hi,

Please help me out to solve this problem, I have following table. Now what 
I want to have result as third column "Combine". 

Srn Name Combine 
1 A A, B, C 
B 
C 
2 D D, E 
E 
3 F F, G, H, I, J 
G 
H 
I 
J 
4 K K 
5 O O, P 
P 

-- 
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s 
=TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ 
https://www.facebook.com/discussexcel

FORUM RULES

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.
2) Don't post a question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any security measure.
4) Acknowledge the responses you receive, good or bad.
5) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.

NOTE  : Don't ever post confidential data in a workbook. Forum owners and 
members are not responsible for any loss.
--- 
You received this message because you are subscribed to the Google Groups "MS 
EXCEL AND VBA MACROS" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to excel-macros+unsubscr...@googlegroups.com.
To post to this group, send email to excel-macros@googlegroups.com.
Visit this group at https://groups.google.com/group/excel-macros.
For more options, visit https://groups.google.com/d/optout.

Re: $$Excel-Macros$$ lookup from list or to find a cell contain any one of the item in the list

[Faisal Pk]

Please check the below formula will work for you, this will count and
return a value above zero if existed in the list.

=COUNTIF(mylist,RIGHT(A1,5))

Regards
Faisal PK

On Sat, Apr 2, 2016 at 6:38 PM, Ganesh N  wrote:

> Dear Team,
>
> Any one can help me out ?
>
> Thanks & Regards,
> Ganesh N
>
> On Sun, Mar 27, 2016 at 9:15 PM, Ganesh N  wrote:
>
>> Dear Team,
>>
>> Any update on my request ?
>>
>> Thanks & Regards,
>> Ganesh N
>>
>> On Sat, Mar 26, 2016 at 7:52 PM, Ganesh N  wrote:
>>
>>> Dear Team,
>>>
>>> Kindly request to help me with some formula to find the cell contains
>>> any item from the list. I have used search formula but it is not working if
>>> the list of item in different order.
>>>
>>> Working in one sheet and list are in another sheet
>>>
>>> If you have any concern kindly let me know.
>>>
>>> Thanks & Regards,
>>> Ganesh N
>>>
>>> --
>>> Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be?
>>> It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
>>> https://www.facebook.com/discussexcel
>>>
>>> FORUM RULES
>>>
>>> 1) Use concise, accurate thread titles. Poor thread titles, like Please
>>> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
>>> will not get quick attention or may not be answered.
>>> 2) Don't post a question in the thread of another member.
>>> 3) Don't post questions regarding breaking or bypassing any security
>>> measure.
>>> 4) Acknowledge the responses you receive, good or bad.
>>> 5) Jobs posting is not allowed.
>>> 6) Sharing copyrighted material and their links is not allowed.
>>>
>>> NOTE : Don't ever post confidential data in a workbook. Forum owners and
>>> members are not responsible for any loss.
>>> ---
>>> You received this message because you are subscribed to the Google
>>> Groups "MS EXCEL AND VBA MACROS" group.
>>> To unsubscribe from this group and stop receiving emails from it, send
>>> an email to excel-macros+unsubscr...@googlegroups.com.
>>> To post to this group, send email to excel-macros@googlegroups.com.
>>> Visit this group at https://groups.google.com/group/excel-macros.
>>> For more options, visit https://groups.google.com/d/optout.
>>>
>>
>>
> --
> Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
> =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
> https://www.facebook.com/discussexcel
>
> FORUM RULES
>
> 1) Use concise, accurate thread titles. Poor thread titles, like Please
> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
> will not get quick attention or may not be answered.
> 2) Don't post a question in the thread of another member.
> 3) Don't post questions regarding breaking or bypassing any security
> measure.
> 4) Acknowledge the responses you receive, good or bad.
> 5) Jobs posting is not allowed.
> 6) Sharing copyrighted material and their links is not allowed.
>
> NOTE : Don't ever post confidential data in a workbook. Forum owners and
> members are not responsible for any loss.
> ---
> You received this message because you are subscribed to the Google Groups
> "MS EXCEL AND VBA MACROS" group.
> To unsubscribe from this group and stop receiving emails from it, send an
> email to excel-macros+unsubscr...@googlegroups.com.
> To post to this group, send email to excel-macros@googlegroups.com.
> Visit this group at https://groups.google.com/group/excel-macros.
> For more options, visit https://groups.google.com/d/optout.
>



-- 
Best Regards
Faisal PK

-- 
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s 
=TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ 
https://www.facebook.com/discussexcel

FORUM RULES

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.
2) Don't post a question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any security measure.
4) Acknowledge the responses you receive, good or bad.
5) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.

NOTE  : Don't ever post confidential data in a workbook. Forum owners and 
members are not responsible for any loss.
--- 
You received this message because you are subscribed to the Google Groups "MS 
EXCEL AND VBA MACROS" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to excel-macros+unsubscr...@googlegroups.com.
To post to this group, send email to excel-macros@googlegroups.com.
Visit this group at https://groups.google.com/group/excel-macros.
For more options, visit https://groups.google.com/d/optout.

Re: $$Excel-Macros$$ lookup from list or to find a cell contain any one of the item in the list

[Ganesh N]

Dear Team,

Any one can help me out ?

Thanks & Regards,
Ganesh N

On Sun, Mar 27, 2016 at 9:15 PM, Ganesh N  wrote:

> Dear Team,
>
> Any update on my request ?
>
> Thanks & Regards,
> Ganesh N
>
> On Sat, Mar 26, 2016 at 7:52 PM, Ganesh N  wrote:
>
>> Dear Team,
>>
>> Kindly request to help me with some formula to find the cell contains any
>> item from the list. I have used search formula but it is not working if the
>> list of item in different order.
>>
>> Working in one sheet and list are in another sheet
>>
>> If you have any concern kindly let me know.
>>
>> Thanks & Regards,
>> Ganesh N
>>
>> --
>> Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
>> =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
>> https://www.facebook.com/discussexcel
>>
>> FORUM RULES
>>
>> 1) Use concise, accurate thread titles. Poor thread titles, like Please
>> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
>> will not get quick attention or may not be answered.
>> 2) Don't post a question in the thread of another member.
>> 3) Don't post questions regarding breaking or bypassing any security
>> measure.
>> 4) Acknowledge the responses you receive, good or bad.
>> 5) Jobs posting is not allowed.
>> 6) Sharing copyrighted material and their links is not allowed.
>>
>> NOTE : Don't ever post confidential data in a workbook. Forum owners and
>> members are not responsible for any loss.
>> ---
>> You received this message because you are subscribed to the Google Groups
>> "MS EXCEL AND VBA MACROS" group.
>> To unsubscribe from this group and stop receiving emails from it, send an
>> email to excel-macros+unsubscr...@googlegroups.com.
>> To post to this group, send email to excel-macros@googlegroups.com.
>> Visit this group at https://groups.google.com/group/excel-macros.
>> For more options, visit https://groups.google.com/d/optout.
>>
>
>

-- 
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s 
=TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ 
https://www.facebook.com/discussexcel

FORUM RULES

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.
2) Don't post a question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any security measure.
4) Acknowledge the responses you receive, good or bad.
5) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.

NOTE  : Don't ever post confidential data in a workbook. Forum owners and 
members are not responsible for any loss.
--- 
You received this message because you are subscribed to the Google Groups "MS 
EXCEL AND VBA MACROS" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to excel-macros+unsubscr...@googlegroups.com.
To post to this group, send email to excel-macros@googlegroups.com.
Visit this group at https://groups.google.com/group/excel-macros.
For more options, visit https://groups.google.com/d/optout.

$$Excel-Macros$$ Re: SAME MACRO FOR MANY CELLS

[NIJ]

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)
>
>   If Range("A1").Value = "ABC" Then
> Rows("12:18").Hidden = True
> 
> End If
> 
> End Sub
>


GREAT, THANKS ALOT FOR SO QUICK RESPONSE. 

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.

-- 
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s 
=TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ 
https://www.facebook.com/discussexcel

FORUM RULES

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.
2) Don't post a question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any security measure.
4) Acknowledge the responses you receive, good or bad.
5) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.

NOTE  : Don't ever post confidential data in a workbook. Forum owners and 
members are not responsible for any loss.
--- 
You received this message because you are subscribed to the Google Groups "MS 
EXCEL AND VBA MACROS" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to excel-macros+unsubscr...@googlegroups.com.
To post to this group, send email to excel-macros@googlegroups.com.
Visit this group at https://groups.google.com/group/excel-macros.
For more options, visit https://groups.google.com/d/optout.

Re: $$Excel-Macros$$ Re: SAME MACRO FOR MANY CELLS

[Sam Mathai Chacko]

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 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)
>>
>>   If Range("A1").Value = "ABC" Then
>> Rows("12:18").Hidden = True
>>
>> End If
>>
>> End Sub
>>
>
> I WANT ANY OF CELL FROM A1 TO G2 IF CONTAIN "ABC" VALUE ROWS GET HIDE.
>
> THANKS FOR RESPONSE
>
> I
>
> --
> Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
> =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
> https://www.facebook.com/discussexcel
>
> FORUM RULES
>
> 1) Use concise, accurate thread titles. Poor thread titles, like Please
> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
> will not get quick attention or may not be answered.
> 2) Don't post a question in the thread of another member.
> 3) Don't post questions regarding breaking or bypassing any security
> measure.
> 4) Acknowledge the responses you receive, good or bad.
> 5) Jobs posting is not allowed.
> 6) Sharing copyrighted material and their links is not allowed.
>
> NOTE : Don't ever post confidential data in a workbook. Forum owners and
> members are not responsible for any loss.
> ---
> You received this message because you are subscribed to the Google Groups
> "MS EXCEL AND VBA MACROS" group.
> To unsubscribe from this group and stop receiving emails from it, send an
> email to excel-macros+unsubscr...@googlegroups.com.
> To post to this group, send email to excel-macros@googlegroups.com.
> Visit this group at https://groups.google.com/group/excel-macros.
> For more options, visit https://groups.google.com/d/optout.
>

-- 
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s 
=TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ 
https://www.facebook.com/discussexcel

FORUM RULES

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.
2) Don't post a question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any security measure.
4) Acknowledge the responses you receive, good or bad.
5) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.

NOTE  : Don't ever post confidential data in a workbook. Forum owners and 
members are not responsible for any loss.
--- 
You received this message because you are subscribed to the Google Groups "MS 
EXCEL AND VBA MACROS" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to excel-macros+unsubscr...@googlegroups.com.
To post to this group, send email to excel-macros@googlegroups.com.
Visit this group at https://groups.google.com/group/excel-macros.
For more options, visit https://groups.google.com/d/optout.

$$Excel-Macros$$ Re: SAME MACRO FOR MANY CELLS

[NIJ]

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)
>
>   If Range("A1").Value = "ABC" Then
> Rows("12:18").Hidden = True
> 
> End If
> 
> End Sub
>

I WANT ANY OF CELL FROM A1 TO G2 IF CONTAIN "ABC" VALUE ROWS GET HIDE.

THANKS FOR RESPONSE

I 

-- 
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s 
=TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ 
https://www.facebook.com/discussexcel

FORUM RULES

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.
2) Don't post a question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any security measure.
4) Acknowledge the responses you receive, good or bad.
5) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.

NOTE  : Don't ever post confidential data in a workbook. Forum owners and 
members are not responsible for any loss.
--- 
You received this message because you are subscribed to the Google Groups "MS 
EXCEL AND VBA MACROS" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to excel-macros+unsubscr...@googlegroups.com.
To post to this group, send email to excel-macros@googlegroups.com.
Visit this group at https://groups.google.com/group/excel-macros.
For more options, visit https://groups.google.com/d/optout.

Re: $$Excel-Macros$$ SAME MACRO FOR MANY CELLS

[Sam Mathai Chacko]

You want to check whether each cell from A1 to G2 has the text "ABC" in it
or not? And if yes, hide the same rows?

On Sat, Apr 2, 2016 at 7:00 PM, 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)
>
>   If Range("A1").Value = "ABC" Then
> Rows("12:18").Hidden = True
>
> End If
>
> End Sub
>
> --
> Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
> =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
> https://www.facebook.com/discussexcel
>
> FORUM RULES
>
> 1) Use concise, accurate thread titles. Poor thread titles, like Please
> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
> will not get quick attention or may not be answered.
> 2) Don't post a question in the thread of another member.
> 3) Don't post questions regarding breaking or bypassing any security
> measure.
> 4) Acknowledge the responses you receive, good or bad.
> 5) Jobs posting is not allowed.
> 6) Sharing copyrighted material and their links is not allowed.
>
> NOTE : Don't ever post confidential data in a workbook. Forum owners and
> members are not responsible for any loss.
> ---
> You received this message because you are subscribed to the Google Groups
> "MS EXCEL AND VBA MACROS" group.
> To unsubscribe from this group and stop receiving emails from it, send an
> email to excel-macros+unsubscr...@googlegroups.com.
> To post to this group, send email to excel-macros@googlegroups.com.
> Visit this group at https://groups.google.com/group/excel-macros.
> For more options, visit https://groups.google.com/d/optout.
>



-- 
Sam Mathai Chacko

-- 
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s 
=TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ 
https://www.facebook.com/discussexcel

FORUM RULES

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.
2) Don't post a question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any security measure.
4) Acknowledge the responses you receive, good or bad.
5) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.

NOTE  : Don't ever post confidential data in a workbook. Forum owners and 
members are not responsible for any loss.
--- 
You received this message because you are subscribed to the Google Groups "MS 
EXCEL AND VBA MACROS" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to excel-macros+unsubscr...@googlegroups.com.
To post to this group, send email to excel-macros@googlegroups.com.
Visit this group at https://groups.google.com/group/excel-macros.
For more options, visit https://groups.google.com/d/optout.

$$Excel-Macros$$ SAME MACRO FOR MANY CELLS

[NIJ]

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)
   
  If Range("A1").Value = "ABC" Then
Rows("12:18").Hidden = True

End If

End Sub

-- 
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s 
=TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ 
https://www.facebook.com/discussexcel

FORUM RULES

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.
2) Don't post a question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any security measure.
4) Acknowledge the responses you receive, good or bad.
5) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.

NOTE  : Don't ever post confidential data in a workbook. Forum owners and 
members are not responsible for any loss.
--- 
You received this message because you are subscribed to the Google Groups "MS 
EXCEL AND VBA MACROS" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to excel-macros+unsubscr...@googlegroups.com.
To post to this group, send email to excel-macros@googlegroups.com.
Visit this group at https://groups.google.com/group/excel-macros.
For more options, visit https://groups.google.com/d/optout.