Re: $$Excel-Macros$$ Count If Cell Contains
Thank you very much On Tuesday, September 8, 2015 2:17 AM, Swapnil Palande wrote: Great...Learned somthing new today... Thanks Abhishek. Regards,Swapnil Palande On Tue, Sep 8, 2015 at 11:33 AM, Abhishek Jain wrote: Just one correction, if I may: Countif(A1:A100,"(IRE)") would only count the cells having exact text as "(IRE)" not those which contain "(IRE)". For that you would have to put an asterisk before and after the look up text so as to do wild card search. Here is what your formula would be: =Countif(A1:A100,"*(IRE)*") You can also refer the search value by using "&" in the formula - please see attached. HTH, Abhishek On Tue, Sep 8, 2015 at 8:37 AM, pankaj sangotra wrote: Assuming data stored in Range A1:A100Put this formula in B1, it will give the count of IRE in the given RangeCountIf(A1:A100,"(IRE)")Use the same again with another criteria CountIf(A1:A100,"(xxx)") -- 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 http://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 http://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 http://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 a
$$Excel-Macros$$ Count If Cell Contains
| Bernardini | | Candy Ride (ARG) | | Candy Ride (ARG) | | Cape Blanco (IRE) | | Cape Cross (IRE) | | Champs Elysees (GB) | | Champs Elysees (GB) | | Congrats | | Curlin | | Danehill Dancer (IRE) | | Dansili (GB) | | Disco Rico | | Hat Trick (JPN) | | Invasor (ARG) | | Kitten's Joy | | Leroidesanimaux (BRZ) | | Lonhro (AUS) | | Mafki (GB) | | Medaglia d'Oro | | Montjeu (IRE) | | New Approach (IRE) | | Read the Footnotes | | Scat Daddy | | Tapit | I've got a column similar to this. I looking for a formula that will count (IRE), (GB), etc etcAny help would be appreciated. Thanks,David Lanne -- 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 http://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/d/optout.
Re: $$Excel-Macros$$ How to learn VBA or MACORS myself at home???
Slaying Excel Dragons by Mike Girvin is a good book. I still can't figure out all the language stuff. But what helped me was recording marcos doing simple stuff, (ex renaming sheets, sorting data, etc) then stepping into the marco and I could see what its doing, which helped down the line when I did something similar. . On Monday, July 14, 2014 1:26 PM, 'DELIN FRANCIS' via MS EXCEL AND VBA MACROS wrote: Dear All, Good day to you I am here with a small request, is there any way to learn basics of VBA , since am not good in VBA or MACROS Is there any books available to learn VBA myself at home ?? like how to use it ?? or what is formulas or syntax using for a conditions ?? please help me i am really interested in learning, but i have no time to go for classes. please advise me what can i do.. thank you all in advance for helping me.. regards Delin F Delin.F -- 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 http://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 http://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/d/optout.
Re: $$Excel-Macros$$ 10 Ways to Use Magical INDIRECT Function
Sorry I zsee I forgot my name
Thanks,
David Lanne
From: David Lanne
To: "excel-macros@googlegroups.com"
Sent: Tuesday, November 15, 2011 1:09 AM
Subject: Re: $$Excel-Macros$$ 10 Ways to Use Magical INDIRECT Function
Thanks for the guide, I'm trying to do something similiar to example 3 but I
can't seem to get my =getphoto cell (C3) to be a picture. Result comes up 0. I
can't seem to get my C3 to accept/format the pic.
My formula is
=indirect("Logos!B"&match('newspaper headlines'!$F$3,Logos!$A$:$A$,0)) My pics
are in col b of Logos and the Text to match is in col A.
From: NOORAIN ANSARI
To: excel-macros@googlegroups.com
Sent: Monday, November 14, 2011 10:04 PM
Subject: Re: $$Excel-Macros$$ 10 Ways to Use Magical INDIRECT Function
Thanks Don,
I have removed all external name range link from file which were showing ref
error.
Aside to Nikhil : In Example 9 Form's Controls has used,which are not in excel
2003 so it is showing error. --
Thanks & regards,
Noorain Ansari
http://excelmacroworld.blogspot.com/
http://noorain-ansari.blogspot.com/
On Tue, Nov 15, 2011 at 12:55 AM, dguillett1 wrote:
That example is using an external file so the defined name shows ref
>
>Don Guillett SalesAid softwaredguille...@gmail.com
>
>From: Nikhil Shah
>Sent: Monday, November 14, 2011 12:43 PM
>To: excel-macros@googlegroups.com
>Subject: Re: $$Excel-Macros$$ 10 Ways to Use Magical INDIRECT Function
>
>Dear Noorain
>
>Excellent Help.
>
>Example 9 - Sheet is showing some error...Can you rectify ?
>
>I am using Office Excel 2003.
>
>Thanks in advance
>
>Nikhil
>
>On Mon, Nov 14, 2011 at 11:58 PM, NOORAIN ANSARI
>wrote:
>Dear Group,
>>
>>Please find attached Sheet to use 10 Simple way to use Indirect Function
>>example..
>>
>>if any one have more examples Kindly share with group.
>>
>>The Excel INDIRECT function takes a text string and converts this into a cell
>>reference.
>>Excel does not understand the text string "B1" to mean a reference to the
>>cell B1. Therefore, if you extract or build up a reference to a cell or range
>>using text, you will need to use the INDIRECT function to convert this into a
>>reference that Excel can understand.
>>The format of the function is :
>>INDIRECT( Ref_text, A1 )
>>
>>Where the arguments are as follows :
>>Ref_text - The text describing the reference
>>A1 - An optional logical argument that defines the style of the Ref_text
>>reference.
>>This can be either :
>>
>> * True - to denote that the reference is in A1 style
>> * False - to denote that the reference is in R1C1 styleIf this argument
>> is omitted, it takes on the default value "True" --
>>Thanks & regards,
>>Noorain Ansari
>>http://excelmacroworld.blogspot.com/
>>http://noorain-ansari.blogspot.com/
>>--
>>FORUM RULES (934+ members already BANNED for violation)
>>
>>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) Cross-promotion of, or links to, forums competitive to this forum in
>>signatures are prohibited.
>>
>>NOTE : Don't ever post personal or confidential data in a workbook. Forum
>>owners and members are not responsible for any loss.
>>
>>--
>>To post to this group, send email to excel-macros@googlegroups.com
>>
>-- FORUM RULES (934+ members already BANNED for violation) 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) Cross-promotion of, or links to, forums competitive to this forum in
>signatures are prohibited. NOTE : Don't ever post personal or confidential
>data in a workbook. Forum owners and members are not responsible for any loss.
>
>-
Re: $$Excel-Macros$$ 10 Ways to Use Magical INDIRECT Function
Thanks for the guide, I'm trying to do something similiar to example 3 but I
can't seem to get my =getphoto cell (C3) to be a picture. Result comes up 0. I
can't seem to get my C3 to accept/format the pic.
My formula is
=indirect("Logos!B"&match('newspaper headlines'!$F$3,Logos!$A$:$A$,0)) My pics
are in col b of Logos and the Text to match is in col A.
From: NOORAIN ANSARI
To: excel-macros@googlegroups.com
Sent: Monday, November 14, 2011 10:04 PM
Subject: Re: $$Excel-Macros$$ 10 Ways to Use Magical INDIRECT Function
Thanks Don,
I have removed all external name range link from file which were showing ref
error.
Aside to Nikhil : In Example 9 Form's Controls has used,which are not in excel
2003 so it is showing error.--
Thanks & regards,
Noorain Ansari
http://excelmacroworld.blogspot.com/
http://noorain-ansari.blogspot.com/
On Tue, Nov 15, 2011 at 12:55 AM, dguillett1 wrote:
That example is using an external file so the defined name shows ref
>
>Don GuillettSalesAid softwaredguille...@gmail.com
>
>From: Nikhil Shah
>Sent: Monday, November 14, 2011 12:43 PM
>To: excel-macros@googlegroups.com
>Subject: Re: $$Excel-Macros$$ 10 Ways to Use Magical INDIRECT Function
>
>Dear Noorain
>
>Excellent Help.
>
>Example 9 - Sheet is showing some error...Can you rectify ?
>
>I am using Office Excel 2003.
>
>Thanks in advance
>
>Nikhil
>
>On Mon, Nov 14, 2011 at 11:58 PM, NOORAIN ANSARI
>wrote:
>Dear Group,
>>
>>Please find attached Sheet to use 10 Simple way to use Indirect Function
>>example..
>>
>>if any one have more examples Kindly share with group.
>>
>>The Excel INDIRECT function takes a text string and converts this into a cell
>>reference.
>>Excel does not understand the text string "B1" to mean a reference to the
>>cell B1. Therefore, if you extract or build up a reference to a cell or range
>>using text, you will need to use the INDIRECT function to convert this into a
>>reference that Excel can understand.
>>The format of the function is :
>>INDIRECT( Ref_text, A1 )
>>
>>Where the arguments are as follows :
>>Ref_text - The text describing the reference
>>A1 - An optional logical argument that defines the style of the Ref_text
>>reference.
>>This can be either :
>>
>> * True - to denote that the reference is in A1 style
>> * False - to denote that the reference is in R1C1 styleIf this argument
>> is omitted, it takes on the default value "True" --
>>Thanks & regards,
>>Noorain Ansari
>>http://excelmacroworld.blogspot.com/
>>http://noorain-ansari.blogspot.com/
>>--
>>FORUM RULES (934+ members already BANNED for violation)
>>
>>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) Cross-promotion of, or links to, forums competitive to this forum in
>>signatures are prohibited.
>>
>>NOTE : Don't ever post personal or confidential data in a workbook. Forum
>>owners and members are not responsible for any loss.
>>
>>--
>>To post to this group, send email to excel-macros@googlegroups.com
>>
>-- FORUM RULES (934+ members already BANNED for violation) 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)
>Cross-promotion of, or links to, forums competitive to this forum in
>signatures are prohibited. NOTE : Don't ever post personal or confidential
>data in a workbook. Forum owners and members are not responsible for any
>loss. --To
> post to this group, send email to excel-macros@googlegroups.com
>-- FORUM RULES (934+ members already BANNED for violation) 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)
>Cross-promotion of, or links to, forums competitive to this forum in
>signatures are prohibited. NOTE : Don't ever post personal or confidential
>data in a workbook. Forum owners a
Re: $$Excel-Macros$$ Re: Doesn't this mean?
Thanks
From: lifescholar
To: MS EXCEL AND VBA MACROS
Sent: Monday, September 5, 2011 2:47 AM
Subject: $$Excel-Macros$$ Re: Doesn't this mean?
If (Range("c32") <> Range("c33")) Then
On Sep 5, 6:06 am, David Lanne wrote:
> Sub OTX()
> '
> ' OTX Macro
> '
> '
> If (c32 <> c33) Then
> End If
> If (c32 = c33) Then
> Range("g32:g33").Select
> Application.Run "OT"
> End If
>
> End Sub
>
> Doesn't this mean if c32 doesn't equal c33 nothing happens,if c32 equals c33
> then it runs "OT". Right now it runs "OT" whether c32/c33 are equal or not.
>
> Thanks,
> David Lanne
--
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links :
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
To post to this group, send email to excel-macros@googlegroups.com
<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel
--
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links :
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
To post to this group, send email to excel-macros@googlegroups.com
<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel
Re: $$Excel-Macros$$ Re: Doesn't this mean?
Thanks
From: NOORAIN ANSARI
To: excel-macros@googlegroups.com
Sent: Monday, September 5, 2011 3:00 AM
Subject: Re: $$Excel-Macros$$ Re: Doesn't this mean?
Dear David,
Pls try it..
Sub Example()
If Sheet1.Range("C32").Value = Sheet1.Range("C33").Value Then
Sheet1.Range("g32:g33").Select
Application.Run "OT"
Else
Exit Sub
end if
End Sub
--
Thanks & regards,
Noorain Ansari
http://excelmacroworld.blogspot.com/
http://noorain-ansari.blogspot.com/
On Mon, Sep 5, 2011 at 12:17 PM, lifescholar
wrote:
If (Range("c32") <> Range("c33")) Then
>
>On Sep 5, 6:06 am, David Lanne wrote:
>> Sub OTX()
>> '
>> ' OTX Macro
>> '
>> '
>> If (c32 <> c33) Then
>> End If
>> If (c32 = c33) Then
>> Range("g32:g33").Select
>> Application.Run "OT"
>> End If
>>
>> End Sub
>>
>> Doesn't this mean if c32 doesn't equal c33 nothing happens,if c32 equals c33
>> then it runs "OT". Right now it runs "OT" whether c32/c33 are equal or not.
>>
>> Thanks,
>> David Lanne
>
>--
>--
>Some important links for excel users:
>1. Follow us on TWITTER for tips tricks and links :
>http://twitter.com/exceldailytip
>2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
>3. Excel tutorials at http://www.excel-macros.blogspot.com
>4. Learn VBA Macros at http://www.quickvba.blogspot.com
>5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>
>To post to this group, send email to excel-macros@googlegroups.com
>
><><><><><><><><><><><><><><><><><><><><><><>
>Like our page on facebook , Just follow below link
>http://www.facebook.com/discussexcel
>
--
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links :
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
To post to this group, send email to excel-macros@googlegroups.com
<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel
--
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links :
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
To post to this group, send email to excel-macros@googlegroups.com
<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel
Re: $$Excel-Macros$$ Doesn't this mean?
Thanks
From: Daniel
To: excel-macros@googlegroups.com
Sent: Monday, September 5, 2011 5:39 AM
Subject: RE: $$Excel-Macros$$ Doesn't this mean?
You have to write [C32] and [C33] (or Range(“C32”), Range(“C33”)). C32 is
considered a variable name, not a range.
HTH
Daniel
De :excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] De la
part de David Lanne
Envoyé : lundi 5 septembre 2011 07:06
À : excel-macros@googlegroups.com
Objet : $$Excel-Macros$$ Doesn't this mean?
Sub OTX()
'
' OTX Macro
'
'
If (c32 <> c33) Then
End If
If (c32 = c33) Then
Range("g32:g33").Select
Application.Run "OT"
End If
End Sub
Doesn't this mean if c32 doesn't equal c33 nothing happens,if c32 equals c33
then it runs "OT". Right now it runs "OT" whether c32/c33 are equal or not.
Thanks,
David Lanne
--
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links :
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
To post to this group, send email to excel-macros@googlegroups.com
<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel--
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links :
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
To post to this group, send email to excel-macros@googlegroups.com
<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel
--
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links :
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
To post to this group, send email to excel-macros@googlegroups.com
<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel
$$Excel-Macros$$ Doesn't this mean?
Sub OTX()
'
' OTX Macro
'
'
If (c32 <> c33) Then
End If
If (c32 = c33) Then
Range("g32:g33").Select
Application.Run "OT"
End If
End Sub
Doesn't this mean if c32 doesn't equal c33 nothing happens,if c32 equals c33
then it runs "OT". Right now it runs "OT" whether c32/c33 are equal or not.
Thanks,
David Lanne
--
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links :
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
To post to this group, send email to excel-macros@googlegroups.com
<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel
Re: $$Excel-Macros$$ VLOOKUP or Similiar
I think you could insert a new column A and use 1,2,3.1000 to label rows From: NOORAIN ANSARI To: excel-macros@googlegroups.com Sent: Sunday, August 28, 2011 7:18 PM Subject: Re: $$Excel-Macros$$ VLOOKUP or Similiar Dear Cab, If possible please provide a sample sheet.. On Mon, Aug 29, 2011 at 4:22 AM, Cab Boose wrote: Hi > > >I have a list of data 5 columns 1000 rows. There are some blank rows in this >list. Sometimes one sometimes several. I do not want to delete the rows. >I want a vlookup function or similiar, to lookup column A for the required >number and copy into normal cell where formula is. That is: just a normal >vllookup function. > >Question: How do I get the vlookup to go past the first blank row ? >Thanks >Charlie-- >-- >Some important links for excel users: >1. Follow us on TWITTER for tips tricks and links : >http://twitter.com/exceldailytip >2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 >3. Excel tutorials at http://www.excel-macros.blogspot.com >4. Learn VBA Macros at http://www.quickvba.blogspot.com >5. Excel Tips and Tricks at http://exceldailytip.blogspot.com > >To post to this group, send email to excel-macros@googlegroups.com > ><><><><><><><><><><><><><><><><><><><><><><> >Like our page on facebook , Just follow below link >http://www.facebook.com/discussexcel > -- Thanks & regards, Noorain Ansari http://noorain-ansari.blogspot.com/ -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com <><><><><><><><><><><><><><><><><><><><><><> Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com <><><><><><><><><><><><><><><><><><><><><><> Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel
Re: $$Excel-Macros$$ Run - Copy / Paste - Repeat Macro
30,432 Thank you's --- On Fri, 4/8/11, Paul Schreiner wrote: From: Paul Schreiner Subject: Re: $$Excel-Macros$$ Run - Copy / Paste - Repeat Macro To: excel-macros@googlegroups.com Date: Friday, April 8, 2011, 7:48 AM I've not tried it with charts, but whenever you do a find/replace (ctrl-h) there is an option to look in formulas. You could copy the sheets, then use find/replace to replace references to Info4 with Info3, etc. Paul From: David Lanne To: excel-macros@googlegroups.com Sent: Thu, April 7, 2011 5:51:07 PM Subject: Re: $$Excel-Macros$$ Run - Copy / Paste - Repeat Macro I have a similar issue. I have 4 workbooks basically (dumb info 1, dumb info 2, etc). The layout/format of the four are the same. The first 76 sheets of each book contains the data. Another 5-10 sheets are use to consolidate. With dumb info 4 I got playing around with graphs and charts. So I have additional 16 pages (1 for each widget) that contains the 76 line item results of each. Since dumb info 4 has only used 30 of its 76 sheets I've been using dynamic cells to update my charts and stuff. Now I want to go back to the earlier 3 wookbooks and incorporate the new sheets I made in dumb info 4. When I go to copy and paste. All the formulas still reference dumb info 4. Without having to go into each formula and change the dumb info 4 line, there must be an easier way? --- On Wed, 4/6/11, ashish koul wrote: From: ashish koul Subject: Re: $$Excel-Macros$$ Run - Copy / Paste - Repeat Macro To: excel-macros@googlegroups.com Date: Wednesday, April 6, 2011, 11:36 PM see if it helps On Wed, Apr 6, 2011 at 11:03 PM, RON SMITH wrote: Here is the file: On Wed, Apr 6, 2011 at 7:01 AM, qcan wrote: Hi, I have this great Monte Carlo Simulation program for blackjack. I am not all that good in VBA, but would like a small macro to run this program, the copy and paste the results to another sheet, then repeat that task again for as many times as I wish. Any takers ? I can forward the spreadsheet to you as I cannot seem to attach it here. Thanks. -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com/ 4. Learn VBA Macros at http://www.quickvba.blogspot.com/ 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com/ To post to this group, send email to excel-macros@googlegroups.com <><><><><><><><><><><><><><><><><><><><><><> Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com <><><><><><><><><><><><><><><><><><><><><><> Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel -- Regards Ashish Koul akoul.blogspot.com akoul.wordpress.com My Linkedin Profile P Before printing, think about the environment. -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com <><><><><><><><><><><><><><><><><><><><><><> Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.
Re: $$Excel-Macros$$ Run - Copy / Paste - Repeat Macro
I have a similar issue. I have 4 workbooks basically (dumb info 1, dumb info 2, etc). The layout/format of the four are the same. The first 76 sheets of each book contains the data. Another 5-10 sheets are use to consolidate. With dumb info 4 I got playing around with graphs and charts. So I have additional 16 pages (1 for each widget) that contains the 76 line item results of each. Since dumb info 4 has only used 30 of its 76 sheets I've been using dynamic cells to update my charts and stuff. Now I want to go back to the earlier 3 wookbooks and incorporate the new sheets I made in dumb info 4. When I go to copy and paste. All the formulas still reference dumb info 4. Without having to go into each formula and change the dumb info 4 line, there must be an easier way? --- On Wed, 4/6/11, ashish koul wrote: From: ashish koul Subject: Re: $$Excel-Macros$$ Run - Copy / Paste - Repeat Macro To: excel-macros@googlegroups.com Date: Wednesday, April 6, 2011, 11:36 PM see if it helps On Wed, Apr 6, 2011 at 11:03 PM, RON SMITH wrote: Here is the file: On Wed, Apr 6, 2011 at 7:01 AM, qcan wrote: Hi, I have this great Monte Carlo Simulation program for blackjack. I am not all that good in VBA, but would like a small macro to run this program, the copy and paste the results to another sheet, then repeat that task again for as many times as I wish. Any takers ? I can forward the spreadsheet to you as I cannot seem to attach it here. Thanks. -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com <><><><><><><><><><><><><><><><><><><><><><> Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com <><><><><><><><><><><><><><><><><><><><><><> Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel -- Regards Ashish Koul akoul.blogspot.com akoul.wordpress.com My Linkedin Profile P Before printing, think about the environment. -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com <><><><><><><><><><><><><><><><><><><><><><> Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com <><><><><><><><><><><><><><><><><><><><><><> Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel
Re: $$Excel-Macros$$ Submit Excel idea or suggestion !
With all the fanasty/real sport stuff it would be nice to have a schedule generator that could do the games with home/away function. Thanks, David --- On Thu, 2/3/11, Ayush wrote: From: Ayush Subject: $$Excel-Macros$$ Submit Excel idea or suggestion ! To: excel-macros@googlegroups.com Date: Thursday, February 3, 2011, 11:35 AM Dear members, Time to think ! I am collecting ideas and new features that you would like to see in upcoming version of MS Excel. The only intent here is to make excel awesome for the users and give feedback to Microsoft on their product. http://goo.gl/mod/psLh My Target is to collect 1000+ ideas. Once achieved, The best five innovative ideas will get $10 gift sponsored by me. There is no limit to submit ideas or features. You can vote the ideas submitted by others. 61 IDEAS already submitted. Do encourage your friends, colleagues and followers to participate in this series. Best Regards, Ayush Jain -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com <><><><><><><><><><><><><><><><><><><><><><> Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com <><><><><><><><><><><><><><><><><><><><><><> Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel
