Re: $$Excel-Macros$$ Noorain Ansari - Most Helpful Member July 2012
Congrats Noorain. As always, your contributions help many. Regards, Sam Mathai Chacko On Fri, Aug 3, 2012 at 11:10 PM, Ayush Jain wrote: > Dear members, > > Noorain Ansari has been selected as 'Most Helpful Member' for the month of > July'12. He has posted 143 posts in July 2012 and helped many forum members > through his excel expertise. > > I truly appreciate his consistency and commitment to the group. He is > really doing great job. > > Thanks to Don, Deba Ranjan, Magnesh, Ashish, Rajan, bpascal, Prince, > Sunita and other folks for helping excel enthusiasts voluntarily !! > Keep posting. > > Regards, > Ayush Jain > Group Manager > Microsoft MVP > > -- > FORUM RULES (986+ 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 > > To unsubscribe, send a blank email to > excel-macros+unsubscr...@googlegroups.com > > > -- Sam Mathai Chacko -- FORUM RULES (986+ 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 To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com
Re: $$Excel-Macros$$ Trace Precedents and Trace Error
:) ending this here. No comments On Fri, Aug 3, 2012 at 10:27 PM, ChilExcel wrote: > 1) I'm trying to say is that no matter if 1 or 2 >to response, if bad or good response anrterior > just answer something to contribute and you! > > 2) yes is a copy of ( > http://www.dummies.com/how-to/content/understanding-excel-2010s-formula-auditing-tools.html) > You will not wait to draft all the text again, there is an effort by > someone else, ..thanks for posting the link > 3) I clearly understand the question, you are who do not understand > rajan did not want links or anything He wanted an answer > this reviewer Rajan.. is what matters !!! > > > Chilexcel > > > > > > 2012/8/3 Sam Mathai Chacko > >> 1. Your post came on top of my post, so there is no way of me proposing >> 'another' solution. >> >> 2. It is not your answer ( >> http://www.dummies.com/how-to/content/understanding-excel-2010s-formula-auditing-tools.html >> ) >> >> 3. There is no reason to feel offended. I was only saying that it was a >> different question, and you probably (apparently) didn't understand what >> was asked. >> >> Sam >> >> >> On Fri, Aug 3, 2012 at 9:51 PM, ChilExcel wrote: >> >>> Mr.Sam Mathai Chacko >>> >>> I only answer queries or questions .. if you do not like my answer >>> you propose another solution .. and everyone happy!!! >>> >>> >>> Chilexcel >>> >>> >>> >>> 2012/8/3 Sam Mathai Chacko >>> >>>> Rajan isn't asking about Formula Auditing, which I am sure he is aware >>>> of. His question is about the difference between Trace Precedents and Trace >>>> Error which are two separate features in Excel. >>>> >>>> Please read my post before. >>>> >>>> Regards, >>>> Sam Mathai Chacko >>>> >>>> >>>> On Fri, Aug 3, 2012 at 9:34 PM, ChilExcel wrote: >>>> >>>>> Rajan >>>>> >>>>> >>>>> >>>>> These tool in Excel allows us to Trace Precedents in a formula, Trace >>>>> Dependents , Show formulas, Error checking and Evaluating formula in >>>>> Excel. >>>>> [image: Imágenes integradas 1] >>>>> >>>>> detail >>>>> >>>>> >>>>> *Trace Precedents:* When you click this button, Excel draws arrows to >>>>> the cells (the so-called *direct precedents*) that are referred to in >>>>> the formula inside the selected cell. When you click this button again, >>>>> Excel adds "tracer" arrows that show the cells (the so-called *indirect >>>>> precedents*) that are referred to in the formulas in the direct >>>>> precedents. >>>>> >>>>> *Trace Dependents:* When you click this button, Excel draws arrows >>>>> from the selected cell to the cells (the so-called *direct dependents*) >>>>> that use, or depend on, the results of the formula in the selected cell. >>>>> When you click this button again, Excel adds tracer arrows identifying the >>>>> cells (the so-called *indirect dependents*) that refer to formulas >>>>> found in the direct dependents. >>>>> >>>>> *Remove Arrows:* Clicking this button (or the Remove Arrows option on >>>>> its drop-down menu) removes all the arrows drawn, no matter what button or >>>>> command you used to put them there. >>>>> >>>>> *Show Formulas:* To display all formulas in their cells in the >>>>> worksheet instead of their calculated values (just like pressing Ctrl+`). >>>>> • *Error Checking*: When you click this button or the Error Checking >>>>> option on its drop-down menu, Excel displays the Error Checking dialog >>>>> box, >>>>> which describes the nature of the error in the current cell, gives you >>>>> help >>>>> on it, and enables you to trace its precedents. Click the Trace Error >>>>> option on this button's drop-down menu to attempt to locate the cell that >>>>> contains the original formula that has an error. Click the Circular >>>>> References option on this button's drop-down menu to display a menu with a >>>>> list of all the cell addresses containing circular references in the >>>>> active >>>
Re: $$Excel-Macros$$ Trace Precedents and Trace Error
1. Your post came on top of my post, so there is no way of me proposing 'another' solution. 2. It is not your answer ( http://www.dummies.com/how-to/content/understanding-excel-2010s-formula-auditing-tools.html ) 3. There is no reason to feel offended. I was only saying that it was a different question, and you probably (apparently) didn't understand what was asked. Sam On Fri, Aug 3, 2012 at 9:51 PM, ChilExcel wrote: > Mr.Sam Mathai Chacko > > I only answer queries or questions .. if you do not like my answer > you propose another solution .. and everyone happy!!! > > > Chilexcel > > > > 2012/8/3 Sam Mathai Chacko > >> Rajan isn't asking about Formula Auditing, which I am sure he is aware >> of. His question is about the difference between Trace Precedents and Trace >> Error which are two separate features in Excel. >> >> Please read my post before. >> >> Regards, >> Sam Mathai Chacko >> >> >> On Fri, Aug 3, 2012 at 9:34 PM, ChilExcel wrote: >> >>> Rajan >>> >>> >>> >>> These tool in Excel allows us to Trace Precedents in a formula, Trace >>> Dependents , Show formulas, Error checking and Evaluating formula in Excel. >>> [image: Imágenes integradas 1] >>> >>> detail >>> >>> >>> *Trace Precedents:* When you click this button, Excel draws arrows to >>> the cells (the so-called *direct precedents*) that are referred to in >>> the formula inside the selected cell. When you click this button again, >>> Excel adds "tracer" arrows that show the cells (the so-called *indirect >>> precedents*) that are referred to in the formulas in the direct >>> precedents. >>> >>> *Trace Dependents:* When you click this button, Excel draws arrows from >>> the selected cell to the cells (the so-called *direct dependents*) that >>> use, or depend on, the results of the formula in the selected cell. When >>> you click this button again, Excel adds tracer arrows identifying the cells >>> (the so-called *indirect dependents*) that refer to formulas found in >>> the direct dependents. >>> >>> *Remove Arrows:* Clicking this button (or the Remove Arrows option on >>> its drop-down menu) removes all the arrows drawn, no matter what button or >>> command you used to put them there. >>> >>> *Show Formulas:* To display all formulas in their cells in the >>> worksheet instead of their calculated values (just like pressing Ctrl+`). >>> • *Error Checking*: When you click this button or the Error Checking >>> option on its drop-down menu, Excel displays the Error Checking dialog box, >>> which describes the nature of the error in the current cell, gives you help >>> on it, and enables you to trace its precedents. Click the Trace Error >>> option on this button's drop-down menu to attempt to locate the cell that >>> contains the original formula that has an error. Click the Circular >>> References option on this button's drop-down menu to display a menu with a >>> list of all the cell addresses containing circular references in the active >>> worksheet. >>> >>> >>> *Evaluate Formula:* Clicking this button opens the Evaluate Formula >>> dialog box, where you can have Excel evaluate each part of the formula in >>> the current cell. The Evaluate Formula feature can be quite useful in >>> formulas that nest many functions within them. >>> >>> Chilexcel >>> >>> 2012/8/3 Rajan_Verma >>> >>>> * * >>>> >>>> *Hi Group,* >>>> >>>> * * >>>> >>>> *Is there any difference in Trace Precedents and Trace Error in Excel?? >>>> * >>>> >>>> * * >>>> >>>> *I don’t need any link to see because I have already Google it.* >>>> >>>> * * >>>> >>>> *Regards* >>>> >>>> *Rajan verma* >>>> >>>> *+91 7838100659 [IM-Gtalk]* >>>> >>>> ** ** >>>> >>>> -- >>>> FORUM RULES (986+ 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. &
Re: $$Excel-Macros$$ Trace Precedents and Trace Error
Rajan isn't asking about Formula Auditing, which I am sure he is aware of. His question is about the difference between Trace Precedents and Trace Error which are two separate features in Excel. Please read my post before. Regards, Sam Mathai Chacko On Fri, Aug 3, 2012 at 9:34 PM, ChilExcel wrote: > Rajan > > > > These tool in Excel allows us to Trace Precedents in a formula, Trace > Dependents , Show formulas, Error checking and Evaluating formula in Excel. > [image: Imágenes integradas 1] > > detail > > > *Trace Precedents:* When you click this button, Excel draws arrows to the > cells (the so-called *direct precedents*) that are referred to in the > formula inside the selected cell. When you click this button again, Excel > adds "tracer" arrows that show the cells (the so-called *indirect > precedents*) that are referred to in the formulas in the direct > precedents. > > *Trace Dependents:* When you click this button, Excel draws arrows from > the selected cell to the cells (the so-called *direct dependents*) that > use, or depend on, the results of the formula in the selected cell. When > you click this button again, Excel adds tracer arrows identifying the cells > (the so-called *indirect dependents*) that refer to formulas found in the > direct dependents. > > *Remove Arrows:* Clicking this button (or the Remove Arrows option on its > drop-down menu) removes all the arrows drawn, no matter what button or > command you used to put them there. > > *Show Formulas:* To display all formulas in their cells in the worksheet > instead of their calculated values (just like pressing Ctrl+`). > • *Error Checking*: When you click this button or the Error Checking > option on its drop-down menu, Excel displays the Error Checking dialog box, > which describes the nature of the error in the current cell, gives you help > on it, and enables you to trace its precedents. Click the Trace Error > option on this button's drop-down menu to attempt to locate the cell that > contains the original formula that has an error. Click the Circular > References option on this button's drop-down menu to display a menu with a > list of all the cell addresses containing circular references in the active > worksheet. > > > *Evaluate Formula:* Clicking this button opens the Evaluate Formula > dialog box, where you can have Excel evaluate each part of the formula in > the current cell. The Evaluate Formula feature can be quite useful in > formulas that nest many functions within them. > > Chilexcel > > 2012/8/3 Rajan_Verma > >> * * >> >> *Hi Group,* >> >> * * >> >> *Is there any difference in Trace Precedents and Trace Error in Excel??* >> >> * * >> >> *I don’t need any link to see because I have already Google it.* >> >> * * >> >> *Regards* >> >> *Rajan verma* >> >> *+91 7838100659 [IM-Gtalk]* >> >> ** ** >> >> -- >> FORUM RULES (986+ 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 >> >> To unsubscribe, send a blank email to >> excel-macros+unsubscr...@googlegroups.com >> >> >> > > > > -- > Visita ; http://sites.google.com/site/chilexcel/Home > Visita ; http://www.youtube.com/user/timextag41 > > -- > FORUM RULES (986+ 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
Re: $$Excel-Macros$$ Trace Precedents and Trace Error
Trace Precendents and Trace Error is different from each other literally as it sounds. For any single cell containing any formula, its precedents are nothing but any cell or cells that it references in that formula. Trace Error on the other hand for any single cell containing any formula, is the precedent cell or cells in that formula that have an error. So a cell traced using the Trace Error will always be a precedent cell of that cell, but a cell traced using the Trace Precedents will not necessarily have an error to be traced with the Trace Error feature. Regards, Sam On Fri, Aug 3, 2012 at 8:42 PM, Rajan_Verma wrote: > * * > > *Hi Group,* > > * * > > *Is there any difference in Trace Precedents and Trace Error in Excel??* > > * * > > *I don’t need any link to see because I have already Google it.* > > * * > > *Regards* > > *Rajan verma* > > *+91 7838100659 [IM-Gtalk]* > > ** ** > > -- > FORUM RULES (986+ 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 > > To unsubscribe, send a blank email to > excel-macros+unsubscr...@googlegroups.com > > > -- Sam Mathai Chacko -- FORUM RULES (986+ 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 To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com
Re: $$Excel-Macros$$ Need Help !!!!
I also second both gentlemen's points. For the solution, use =SUMPRODUCT(($A$2:$A$10=$G$13)*($B$2:$B$10=$G14)*(C$2:C$10)) dragged down and across Regards, Sam Mathai Chacko On Tue, Jul 31, 2012 at 12:10 AM, dguillett1 wrote: > I did not look at your file because you subject line did not have a > meaningful question and you did not ask your question in the body of the > email. It is good that you did provide a file. > > Don Guillett > Microsoft Excel Developer > SalesAid Software > dguille...@gmail.com > > *From:* Mangesh Vimay > *Sent:* Monday, July 30, 2012 12:40 PM > *To:* excel-macros@googlegroups.com > *Subject:* $$Excel-Macros$$ Need Help > > Hi Friends, > > Please help me on the sheet provided as an attachment. > Waiting for your reply !!! > Thanks ! > > -- > With regards, > > MaNgEsH > > -- > FORUM RULES (986+ 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 > > To unsubscribe, send a blank email to > excel-macros+unsubscr...@googlegroups.com > > > > -- > FORUM RULES (986+ 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 > > To unsubscribe, send a blank email to > excel-macros+unsubscr...@googlegroups.com > > > -- Sam Mathai Chacko -- FORUM RULES (986+ 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 To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com
Re: $$Excel-Macros$$ How to calculate Days and Time.
Either way, you need to consider the time difference between both the countries. Only then will you actually be able to calculate the overall time consumed for the dispatch to be delivered. Sam Mathai Chacko On Mon, Jul 30, 2012 at 11:25 PM, Paul Schreiner wrote: > What kind of solution are you looking for? > A formula or VBA? > > > > > *Paul* > > - > *“Do all the good you can, > By all the means you can, > In all the ways you can, > In all the places you can, > At all the times you can, > To all the people you can, > As long as ever you can.” - John Wesley > *- > > > -- > *From:* kumar.ashish861 > *To:* excel-macros@googlegroups.com > *Sent:* Mon, July 30, 2012 1:40:26 PM > *Subject:* $$Excel-Macros$$ How to calculate Days and Time. > > > > Hi Champs, > > Please help regarding how to implement Time Consumed formula. Thanks in > Advance. > > > Courier Dispatch from Delhi Courier Received in USA > Time Consumed > Time / Date Time /Date >Days / (Time) in Hrs/Min/Sec > 11:30 AM / 8-Jul-20121:45 PM / 17-Jul-2012 > _ > > > > > Thanks > Ashish kumar > > -- > FORUM RULES (986+ 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 > > To unsubscribe, send a blank email to > excel-macros+unsubscr...@googlegroups.com > > > > -- > FORUM RULES (986+ 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 > > To unsubscribe, send a blank email to > excel-macros+unsubscr...@googlegroups.com > > > -- Sam Mathai Chacko -- FORUM RULES (986+ 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 To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com
Re: $$Excel-Macros$$ Re: Pls tell me more about Areas Property of the Range
Not necessarily a Union function. Even if you select two ranges of cells
using the CTRL key, and then say Selection.Areas.Count, it will give the
number of selections made as different groups of cells.
Regards,
Sam
On Mon, Jul 30, 2012 at 9:25 PM, Prince Dubey wrote:
> Hi Sam,
>
>
> Thanks for your help .As i saw the result i guess that Areas property
> return cluster of range when there is a range created by using union
> function.
>
> regards
>
> prince
>
>
> On Sunday, 29 July 2012 00:28:46 UTC+5:30, Prince Dubey wrote:
>>
>> Hi All,
>>
>>
>> I want to know more about Areas property of the range object,
>>
>> If I write: Range("A1").Areas(1) it return text inside that range but i
>> m not able to to understand what is it. And further if we write it like
>> range("A1").Areas.Count or range("A1").Areas.Creator
>> or range("A1").Areas.Parent , I m not able understand these.
>>
>>
>> Actually i m confused about these statements because i was expecting that
>> areas will return Areas ie # on of cells in that range, But it is not in
>> actual.
>>
>>
>> Prince Dubey.
>>
>>
>>
>>
>> --
> FORUM RULES (986+ 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
>
> To unsubscribe, send a blank email to
> excel-macros+unsubscr...@googlegroups.com
>
>
>
--
Sam Mathai Chacko
--
FORUM RULES (986+ 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
To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com
Re: $$Excel-Macros$$ Re: Pls tell me more about Areas Property of the Range
variable rng used as obj.. revised
Sub T()
Dim rngCluster As Range
Dim rng As Range
Set rngCluster = Application.Union(Range("A1:C3"), Range("D5:E10"))
For Each rng In rngCluster.Areas
MsgBox rng.Address
Next rng
End Sub
On Sun, Jul 29, 2012 at 5:05 PM, Sam Mathai Chacko wrote:
> Prince,
>
> I missed the part about selecting to contiguous cell groups. And come to
> think of it, it doesn't necessarily have to be non-empty.
>
> Try this
>
> Sub T()
>
> Dim rngCluster As Range
> Dim rng As Range
>
> Set rngCluster = Application.Union(Range("A1:C3"), Range("D5:E10"))
> MsgBox rngCluster.Areas.Count
> For Each obj In rngCluster.Areas
> MsgBox obj.Address
> Next obj
>
> End Sub
>
> Regards,
> Sam Mathai Chacko
>
>
> On Sun, Jul 29, 2012 at 4:33 PM, Prince Dubey wrote:
>
>> Hi Sam,
>>
>>
>> Thanks for the reply,
>> I did the same as you have mentioned in your post i created a range A1:E9
>> in which i inserted data from A1:C3 and then D5:E9 and i wrote
>> Sheet1.range(A1:E9).Areas(1).Address but it returned $A$1:$E$9 as address
>> and in case of Sheet1.range(A1:E9).Areas(1).count it returned 1 .
>>
>>
>> regards
>>
>> On Sunday, 29 July 2012 00:28:46 UTC+5:30, Prince Dubey wrote:
>>>
>>> Hi All,
>>>
>>>
>>> I want to know more about Areas property of the range object,
>>>
>>> If I write: Range("A1").Areas(1) it return text inside that range but
>>> i m not able to to understand what is it. And further if we write it like
>>> range("A1").Areas.Count or range("A1").Areas.Creator
>>> or range("A1").Areas.Parent , I m not able understand these.
>>>
>>>
>>> Actually i m confused about these statements because i was expecting
>>> that areas will return Areas ie # on of cells in that range, But it is not
>>> in actual.
>>>
>>>
>>> Prince Dubey.
>>>
>>>
>>>
>>>
>>> --
>> FORUM RULES (986+ 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
>>
>> To unsubscribe, send a blank email to
>> excel-macros+unsubscr...@googlegroups.com
>>
>>
>>
>
>
>
> --
> Sam Mathai Chacko
>
--
Sam Mathai Chacko
--
FORUM RULES (986+ 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
To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com
Re: $$Excel-Macros$$ Re: Pls tell me more about Areas Property of the Range
Prince,
I missed the part about selecting to contiguous cell groups. And come to
think of it, it doesn't necessarily have to be non-empty.
Try this
Sub T()
Dim rngCluster As Range
Dim rng As Range
Set rngCluster = Application.Union(Range("A1:C3"), Range("D5:E10"))
MsgBox rngCluster.Areas.Count
For Each obj In rngCluster.Areas
MsgBox obj.Address
Next obj
End Sub
Regards,
Sam Mathai Chacko
On Sun, Jul 29, 2012 at 4:33 PM, Prince Dubey wrote:
> Hi Sam,
>
>
> Thanks for the reply,
> I did the same as you have mentioned in your post i created a range A1:E9
> in which i inserted data from A1:C3 and then D5:E9 and i wrote
> Sheet1.range(A1:E9).Areas(1).Address but it returned $A$1:$E$9 as address
> and in case of Sheet1.range(A1:E9).Areas(1).count it returned 1 .
>
>
> regards
>
> On Sunday, 29 July 2012 00:28:46 UTC+5:30, Prince Dubey wrote:
>>
>> Hi All,
>>
>>
>> I want to know more about Areas property of the range object,
>>
>> If I write: Range("A1").Areas(1) it return text inside that range but i
>> m not able to to understand what is it. And further if we write it like
>> range("A1").Areas.Count or range("A1").Areas.Creator
>> or range("A1").Areas.Parent , I m not able understand these.
>>
>>
>> Actually i m confused about these statements because i was expecting that
>> areas will return Areas ie # on of cells in that range, But it is not in
>> actual.
>>
>>
>> Prince Dubey.
>>
>>
>>
>>
>> --
> FORUM RULES (986+ 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
>
> To unsubscribe, send a blank email to
> excel-macros+unsubscr...@googlegroups.com
>
>
>
--
Sam Mathai Chacko
--
FORUM RULES (986+ 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
To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com
Re: $$Excel-Macros$$ Pls tell me more about Areas Property of the Range
Basically the key thing to understand is the groups of contiguous
non-empty cells in the parent range.
On 7/29/12, Sam Mathai Chacko wrote:
> Prince,
>
> First of all, let us get the idea of an Area correct. An Area is the
> number of clusters of contiguous cells in a range. By cluster I mean a
> set of adjacent group of cells.
>
> So, for example if you have some non-empty cells in A1 to C3 and D5 to
> E10, then Range(A1:E10).Areas(1).Address will be A1:C3 in absolutes.
> Similarly, .Areas.Count will be 2. .Areas(2).Parent.Address will be
> D5:E10 in absolutes. the .parent will always be the parent object of
> the range object.
>
> On 7/29/12, Prince Dubey wrote:
>> Hi All,
>>
>>
>> I want to know more about Areas property of the range object,
>>
>> If I write: Range("A1").Areas(1) it return text inside that range but i
>> m
>>
>> not able to to understand what is it. And further if we write it like
>> range("A1").Areas.Count or range("A1").Areas.Creator
>> or range("A1").Areas.Parent , I m not able understand these.
>>
>>
>> Actually i m confused about these statements because i was expecting that
>> areas will return Areas ie # on of cells in that range, But it is not in
>> actual.
>>
>>
>> Prince Dubey.
>>
>>
>>
>>
>> --
>> FORUM RULES (986+ 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
>>
>> To unsubscribe, send a blank email to
>> excel-macros+unsubscr...@googlegroups.com
>>
>>
>>
>
>
> --
> Sam Mathai Chacko
>
--
Sam Mathai Chacko
--
FORUM RULES (986+ 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
To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com
Re: $$Excel-Macros$$ Pls tell me more about Areas Property of the Range
Prince,
First of all, let us get the idea of an Area correct. An Area is the
number of clusters of contiguous cells in a range. By cluster I mean a
set of adjacent group of cells.
So, for example if you have some non-empty cells in A1 to C3 and D5 to
E10, then Range(A1:E10).Areas(1).Address will be A1:C3 in absolutes.
Similarly, .Areas.Count will be 2. .Areas(2).Parent.Address will be
D5:E10 in absolutes. the .parent will always be the parent object of
the range object.
On 7/29/12, Prince Dubey wrote:
> Hi All,
>
>
> I want to know more about Areas property of the range object,
>
> If I write: Range("A1").Areas(1) it return text inside that range but i m
>
> not able to to understand what is it. And further if we write it like
> range("A1").Areas.Count or range("A1").Areas.Creator
> or range("A1").Areas.Parent , I m not able understand these.
>
>
> Actually i m confused about these statements because i was expecting that
> areas will return Areas ie # on of cells in that range, But it is not in
> actual.
>
>
> Prince Dubey.
>
>
>
>
> --
> FORUM RULES (986+ 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
>
> To unsubscribe, send a blank email to
> excel-macros+unsubscr...@googlegroups.com
>
>
>
--
Sam Mathai Chacko
--
FORUM RULES (986+ 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
To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com
Re: $$Excel-Macros$$ watch help
by effect you mean how other sheets are linked to that sheet by formula, why don't you try looking at the trace dependants feature in the formula tab of Excel. On 7/29/12, danial mansoor wrote: > > > Dear experts, > > i have bunch of sheets which was created by someone else,i have one input > sheet it effects many sheets is there a way where i could see my input > effects which sheets results?.is there any easy way?navigation on every > sheet is quite hectic could any one suggest easy way or macro or some thing > like that? > > i just wanted to see my input effect which sheets in one glance is there a > way i could do this? > > > regarads, > > daniyal mansoor > > > -- > FORUM RULES (986+ 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 > > To unsubscribe, send a blank email to > excel-macros+unsubscr...@googlegroups.com > > > -- Sam Mathai Chacko -- FORUM RULES (986+ 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 To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com
Re: $$Excel-Macros$$ Turning a if macro to a select case macro
Why not use this.
Select Case Cells(2, j).Value
Case "sexta-feira"
Select Case Cells(i, 1).Value
Case *512, 513, 516*
MsgBox "Yay"
Case Else
MsgBox "Aw"
End Select
Case Else
'Do Nothing
End Select
Regards,
Sam Mathai Chacko
On Fri, Jul 27, 2012 at 7:27 PM, Jorge Marques wrote:
> Hi,
> Ok I looked in several forums none explained, I only noticed then the code
> only returns 1 Case or "OR", the issue is that I have a Shops in this case
> they are code 513, 512, 516, and if it is "Sexta-feira" (Friday) that
> should sum the values one day ahead. My idea of Case statement was just
> trying to avoid several If statements, so I thought Case would be a
> solution.
>
> I´ll try your suggestion and adapt to the rules. Meanwhile I attached the
> file that I forgot, sorry for that. Thanks :)
>
>
>
>
> 2012/7/27 Paul Schreiner
>
>> The "Select Case" condition could be used to replace a "OR" condition.
>> not really an "AND" condition.
>> Kind-of.
>> It's really more like replacing ElseIF.
>>
>> For instance, you could use:
>> both of these examples yield the same result:
>>
>> '
>> TestVal = "three"
>> '
>> Select Case UCase(TestVal)
>> Case "ONE"
>> MsgBox "TestVal = ONE"
>> Case "TWO"
>> MsgBox "TestVal = TWO"
>> Case "THREE"
>> MsgBox "TestVal = THREE"
>> Case "FOUR"
>> MsgBox "TestVal = FOUR"
>> Case Else
>> MsgBox "TestVal is not a member of the expected list"
>> End Select
>> '
>> If (UCase(TestVal) = "ONE") Then
>> MsgBox "TestVal = ONE"
>> ElseIf (UCase(TestVal) = "TWO") Then
>> MsgBox "TestVal = TWO"
>> ElseIf (UCase(TestVal) = "THREE") Then
>> MsgBox "TestVal = THREE"
>> ElseIf (UCase(TestVal) = "FOUR") Then
>> MsgBox "TestVal = FOUR"
>> Else
>> MsgBox "TestVal is not a member of the expected list"
>> End If
>> '
>>
>> In your example, I think the problem is with the conditional "grouping"
>> you need to use ( ) to group the things together, like;
>> If (((Cells(2, j).Value = "sexta-feira") And (Cells(i, 1).Value = 512)) _
>> Or ((Cells(2, j).Value = "sexta-feira") And (Cells(i, 1).Value = 513)) _
>> Or ((Cells(2, j).Value = "sexta-feira") And (Cells(i, 1).Value = 516)) _
>> ) Then
>> End If
>> '
>> Since the first part of each -And- condition is the same, you could use:
>> If ((Cells(2, j).Value = "sexta-feira") And _
>> ((Cells(i, 1).Value = 512) _
>> Or (Cells(i, 1).Value = 513) _
>> Or (Cells(i, 1).Value = 516) _
>>)) Then
>> End If
>>
>> '
>> If you absolutely INSIST that you need to use a "case" statement,
>> then I suppose you could use:
>>
>> If (Cells(2, j).Value = "sexta-feira") Then
>> Select Case (Cells(i, 1).Value)
>> Case 512
>>
>> Cells(i, j + 1).Value = Cells(i, j + 1).Value + Cells(i,
>> j).Value
>> Case 513
>>
>> Cells(i, j + 1).Value = Cells(i, j + 1).Value + Cells(i,
>> j).Value
>> Case 516
>>
>> Cells(i, j + 1).Value = Cells(i, j + 1).Value + Cells(i,
>> j).Value
>> End Select
>> End If
>> '
>>
>>
>> *Paul*
>>
>> -
>> *“Do all the good you can,
>> By all the means you can,
>> In all the ways you can,
>> In all the places you can,
>> At all the times you can,
>> To all the people you can,
>> As long as ever yo
Re: $$Excel-Macros$$ need formulae to pick next highest value by checking two values - 1) text and 2) number
Anyway, if you want to pick the last column, use =INDEX(OFFSET($A$2:$A$22,0,MATCH(A53,$B$1:$V$1)),MATCH(A54,OFFSET($A$2:$A$22,0,MATCH(A53,$B$1:$V$1)),1)+1) If you want to pick the first column, use =INDEX(OFFSET($A$2:$A$22,0,MATCH(A53,$B$1:$V$1,0)),MATCH(A54,OFFSET($A$2:$A$22,0,MATCH(A53,$B$1:$V$1,0)),1)+1) But if you want to use column I, just use =INDEX($I$2:$I$22,MATCH(A54,$I$2:$I$22)+1) Regards, Sam Mathai Chacko On Sat, Jul 21, 2012 at 11:39 PM, Sam Mathai Chacko wrote: > As a MOF, 6150FLA is in Column L also. What is your logic of using the > second instance of this value? > > > On Sat, Jul 21, 2012 at 11:30 PM, Sam Mathai Chacko wrote: > >> Column G also has the same text as column header. How do you decide >> whether it is column G, or column I?? >> >> Sam >> >> >> On Sat, Jul 21, 2012 at 10:51 PM, vijay yadav < >> vijay.ganesh.ya...@gmail.com> wrote: >> >>> Dear Friends/ Excel Experts >>> >>> I need formulae to pick next highest value by checking two input values >>> 1) text and 2)number >>> >>> input cells are A53 (TEXT) and A54(NUMBER) >>> >>> formuale should OUTPUT NEXT highest value to number in A54 >>> >>> TEXT IS COMPARED TO A NUMBER OF TEXT ENTRIES IN ROW 1 >>> AND NUMBER IS IN CORRESPONDING COLUMN FROM ROW 1 TO 34 >>> >>> I have attached the sheet with detailed understanding of problem >>> Please help >>> >>> Example >>> ROW1) BAT BALL CHAIR CYCLE WATCH PEN MAT >>> ROW 2 ) ALL NUMBERS >>> . ALL NUMBERS >>> . ALL NUMBERS >>> ROW 34 ALL NUMBERS >>> >>> A53 = BAT A54 = NUMBER >>> >>> OUTPUT SHOULD BE IN A55 AS A FORMULAE >>> FORMULAE SHOULD READ NEXT HIGHEST NUMBER TO NUMBER IN A54 BELOW "BAT" >>> AND OUTPUT IT IN THE CELL A55 >>> >>> Regards >>> Vijay >>> >>> -- >>> -- >>> FORUM RULES (986+ 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 >>> >>> To unsubscribe, send a blank email to >>> excel-macros+unsubscr...@googlegroups.com >>> >>> >>> >> >> >> >> -- >> Sam Mathai Chacko >> > > > > -- > Sam Mathai Chacko > -- Sam Mathai Chacko -- -- FORUM RULES (986+ 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 To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com
Re: $$Excel-Macros$$ need formulae to pick next highest value by checking two values - 1) text and 2) number
As a MOF, 6150FLA is in Column L also. What is your logic of using the second instance of this value? On Sat, Jul 21, 2012 at 11:30 PM, Sam Mathai Chacko wrote: > Column G also has the same text as column header. How do you decide > whether it is column G, or column I?? > > Sam > > > On Sat, Jul 21, 2012 at 10:51 PM, vijay yadav < > vijay.ganesh.ya...@gmail.com> wrote: > >> Dear Friends/ Excel Experts >> >> I need formulae to pick next highest value by checking two input values >> 1) text and 2)number >> >> input cells are A53 (TEXT) and A54(NUMBER) >> >> formuale should OUTPUT NEXT highest value to number in A54 >> >> TEXT IS COMPARED TO A NUMBER OF TEXT ENTRIES IN ROW 1 >> AND NUMBER IS IN CORRESPONDING COLUMN FROM ROW 1 TO 34 >> >> I have attached the sheet with detailed understanding of problem >> Please help >> >> Example >> ROW1) BAT BALL CHAIR CYCLE WATCH PEN MAT >> ROW 2 ) ALL NUMBERS >> . ALL NUMBERS >> . ALL NUMBERS >> ROW 34 ALL NUMBERS >> >> A53 = BAT A54 = NUMBER >> >> OUTPUT SHOULD BE IN A55 AS A FORMULAE >> FORMULAE SHOULD READ NEXT HIGHEST NUMBER TO NUMBER IN A54 BELOW "BAT" >> AND OUTPUT IT IN THE CELL A55 >> >> Regards >> Vijay >> >> -- >> -- >> FORUM RULES (986+ 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 >> >> To unsubscribe, send a blank email to >> excel-macros+unsubscr...@googlegroups.com >> >> >> > > > > -- > Sam Mathai Chacko > -- Sam Mathai Chacko -- -- FORUM RULES (986+ 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 To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com
Re: $$Excel-Macros$$ need formulae to pick next highest value by checking two values - 1) text and 2) number
Column G also has the same text as column header. How do you decide whether it is column G, or column I?? Sam On Sat, Jul 21, 2012 at 10:51 PM, vijay yadav wrote: > Dear Friends/ Excel Experts > > I need formulae to pick next highest value by checking two input values 1) > text and 2)number > > input cells are A53 (TEXT) and A54(NUMBER) > > formuale should OUTPUT NEXT highest value to number in A54 > > TEXT IS COMPARED TO A NUMBER OF TEXT ENTRIES IN ROW 1 > AND NUMBER IS IN CORRESPONDING COLUMN FROM ROW 1 TO 34 > > I have attached the sheet with detailed understanding of problem > Please help > > Example > ROW1) BAT BALL CHAIR CYCLE WATCH PEN MAT > ROW 2 ) ALL NUMBERS > . ALL NUMBERS > . ALL NUMBERS > ROW 34 ALL NUMBERS > > A53 = BAT A54 = NUMBER > > OUTPUT SHOULD BE IN A55 AS A FORMULAE > FORMULAE SHOULD READ NEXT HIGHEST NUMBER TO NUMBER IN A54 BELOW "BAT" AND > OUTPUT IT IN THE CELL A55 > > Regards > Vijay > > -- > -- > FORUM RULES (986+ 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 > > To unsubscribe, send a blank email to > excel-macros+unsubscr...@googlegroups.com > > > -- Sam Mathai Chacko -- -- FORUM RULES (986+ 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 To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com
Re: $$Excel-Macros$$ How to Convert words in digits.
Your question and title are contradicting. Do you want to convert words to numbers, or vice versa? Regards, Sam Mathai Chacko On Mon, Jul 16, 2012 at 11:15 PM, kumar.ashish861 wrote: > Dear All, > > Kindly help me to convert numbers in digits. I'll apply the formula > "spellnums" but, I think this formula is working only in Office 2003. > please help me to convert this, & is this possible to convert it with > formula not with the help of VB codeing. > > EXAMPLE:- > > Two lacs Two thousand twenty five only. = 220025/- > > > Thanks > Ashish Kumar > > -- > FORUM RULES (986+ 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 > > To unsubscribe, send a blank email to > excel-macros+unsubscr...@googlegroups.com -- Sam Mathai Chacko -- FORUM RULES (986+ 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 To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com
Re: $$Excel-Macros$$ keep selected custom menu tab
Try this, might help. http://www.excelfox.com/forum/f10/activate-ribbon-tab-excel-2007-2010-a-50/ If it doesn't, can you post your XML code? Regards, Sam Mathai Chacko On Thu, Jul 5, 2012 at 5:59 PM, Divaker Pandey wrote: > Hi Group, > > I made a custom menu and ribbon icon using xml in my workbook. I want to > keep selected the created custom menu everytime whenever workbook activated. > > > Divaker > > -- > FORUM RULES (986+ 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 > > To unsubscribe, send a blank email to > excel-macros+unsubscr...@googlegroups.com -- Sam Mathai Chacko -- FORUM RULES (986+ 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 To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com
Re: $$Excel-Macros$$ Rajan Verma - Most helpful Member(June'12)
Excellent stuff! Sam On Wed, Jul 4, 2012 at 9:50 PM, Hilary Lomotey wrote: > Congrats Raj, keep it up > > > On Wed, Jul 4, 2012 at 4:16 PM, Ayush Jain wrote: > >> Hello Everyone, >> >> Rajan Verma has been selected as 'Most Helpful Member' for the month of >> June'2012. This is third time in row. :) >> He has posted 149 posts in June 2012 and helped many people through his >> expertise. >> >> I truly appreciate his consistency and commitment to group. He is really >> doing great job. >> >> Thanks to Noorain, Deba Ranjan, Don, David, Lalit, Lokesh, Hilary, Asa >> and other folks for helping excel enthusiasts voluntarily !! Keep it up !! >> >> Keep posting. >> >> Regards >> Ayush Jain >> Group Manager , Microsoft MVP >> >> -- >> FORUM RULES (986+ 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 >> >> To unsubscribe, send a blank email to >> excel-macros+unsubscr...@googlegroups.com > > > -- > FORUM RULES (986+ 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 > > To unsubscribe, send a blank email to > excel-macros+unsubscr...@googlegroups.com > -- Sam Mathai Chacko -- FORUM RULES (986+ 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 To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com
Re: $$Excel-Macros$$ MVP Award....Congratulations Ashish Koul and Dilip Pandey !!
Excellent achievement once again by Ashish and Dilip. Kuddos to both. Regards, Sam Mathai Chacko On Mon, Jul 2, 2012 at 7:32 PM, ashish koul wrote: > Thank you all... > > > On Mon, Jul 2, 2012 at 4:39 PM, Amol Shrivastava wrote: > >> *Congratulations Ashish and Dilip...!!* >> >> -- >> Thanks & Regards, >> >> Amol Shrivastava >> +91 99671 18180 >> >> >> >> >> On Mon, Jul 2, 2012 at 4:35 PM, Aindril De wrote: >> >>> Congratulations Ashish and Dilip!! >>> Your Contributions have always been an asset to our group.. >>> >>> Hard Luck Don...!! >>> Your contributions have always been really helpful in our group.. >>> Better luck next time!! >>> >>> Cheers >>> Andy >>> >>> On Sun, Jul 1, 2012 at 9:54 PM, Ayush Jain wrote: >>> >>>> Dear members, >>>> >>>> I am extremely happy to inform you that two members of the group are >>>> awarded Microsoft Most Valuable Professional Award. >>>> My heartiest congratulations to *Ashish koul* and *Dilip Pandey* and >>>> thanks for their big support to this forum. >>>> >>>> Keep posting ! >>>> >>>> Best regards, >>>> Ayush Jain >>>> Group Manager >>>> Microsoft MVP >>>> >>>> >>>> >>>> >>>> -- >>>> FORUM RULES (986+ 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 >>>> >>>> To unsubscribe, send a blank email to >>>> excel-macros+unsubscr...@googlegroups.com >>> >>> >>> >>> >>> -- >>> >>> Warm Regards, >>> Aindril De >>> Ph: 9811300157 >>> >>> -- >>> FORUM RULES (986+ 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 >>> >>> To unsubscribe, send a blank email to >>> excel-macros+unsubscr...@googlegroups.com >>> >> >> >> >> -- >> Thanks & Regards, >> >> Amol Shrivastava >> +91 99671 18180 >> >> >> >> > > > -- > *Regards* > * * > *Ashish Koul* > *http://www.excelvbamacros.com/* > *http://www.accessvbamacros.com/* <http://www.accessvbamacros.com/> > > > P Before printing, think about the environment. > > > -- > FORUM RULES (986+ members already BANNED for violation) > > 1) Use concise, accurate thread titles. Poor thread titles, like Please > Help, Urgent, Need Help, Formula Probl
Re: $$Excel-Macros$$ Re: want data seperated by hypen - and comma , to be written in rows existing below eg X6-1,4,5,6,9,X7-23,56,67,X30 in cell c34 to be written as X6-1 in cell c34 X6-4 in cell c35
String
>>
>> Set rngRange = ActiveSheet.Range("A1")
>>
>> varVal = Split(rngRange.Value, ",")
>> For lngLoop = LBound(varVal) To UBound(varVal)
>> If LCase(varVal(lngLoop)) Like "x*" Then
>> strIni = varVal(lngLoop)
>> strFinal = strIni
>> Else
>> strFinal = Split(strIni, "-")(0) & "-" & varVal(lngLoop)
>> End If
>> rngRange.Offset(lngLoop) = strFinal
>> Next lngLoop
>>
>> End Sub
>>
>>
>>
>> change accordingly
>>
>>
>>
>>
>>
>> Regards,
>>
>> Lalit Mohan
>>
>> --
>> FORUM RULES (986+ 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
>>
>> To unsubscribe, send a blank email to excel-macros+unsubscribe@**
>> googlegroups.com
>>
> --
> FORUM RULES (986+ 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
>
> To unsubscribe, send a blank email to
> excel-macros+unsubscr...@googlegroups.com
>
--
Sam Mathai Chacko
--
FORUM RULES (986+ 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
To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com
Re: $$Excel-Macros$$ Re: Join Sql statement in VB using ADODB
Not necessarily! Regards, Sam On Sun, Jun 24, 2012 at 8:40 AM, David Grugeon wrote: > I thought SQL required all statements to end in a semicolon ?? > > > On Sunday, 24 June 2012, TJ wrote: > >> Thanks much >> >> I went ahead a copied that into the Editor and it looks like it added a >> few quotes and arranged some things automatically. Assume some sort of >> autocorrect mechanism. Ran it and it threw a "Run Time error '424': >> Object Required" on the "VV_VESSEL_VISIT.VESSEL_ID , >> VV_VESSEL_VISIT.ARR_VOYAGE, " " line. >> >> Thanks again. >> >> Sub Get_Vessel_Schedule() >> Dim cn As ADODB.Connection >> Dim rs As ADODB.Recordset >> Dim strSql As String >> >> Set cn = New ADODB.Connection >> Set rs = New ADODB.Recordset >> cn.Open ( _ >> "User ID=" & _ >> ";Password=" & _ >> ";Data Source=mit.world" & _ >> ";Provider=MSDAORA.1") >> >> strSql = "" >> strSql = strSql & vbLf & "select VESSEL.CODE, VESSEL.NAME, " >> VV_VESSEL_VISIT.VESSEL_ID , VV_VESSEL_VISIT.ARR_VOYAGE, " " >> strSql = strSql & vbLf & "VV_VESSEL_VISIT.DEP_VOYAGE, " >> VV_VESSEL_VISIT.BERTH , VV_VESSEL_VISIT.MPH, " " >> strSql = strSql & vbLf & "VV_VESSEL_VISIT.ESC_FORWARD_DRAFT, " >> VV_VESSEL_VISIT.ATA , VV_VESSEL_VISIT.ATD, " " >> strSql = strSql & vbLf & "VV_VESSEL_VISIT.ETA, VV_VESSEL_VISIT.ETD from >> VV_VESSEL_VISIT" >> strSql = strSql & vbLf & "join" >> strSql = strSql & vbLf & "VESSEL on VV_VESSEL_VISIT.VESSEL_ID=VESSEL.ID" >> rs.Open strSql, cn >> Cells(6, 6).CopyFromRecordset rs >> End Sub >> >> On Friday, June 22, 2012 7:14:55 PM UTC-5, TJ wrote: >> >>> Hello, >>> >>> Super new to thsi world but trying to put something together that will >>> execute a simple SQL statement against on of our Oracle Databases and >>> return the results. The Code for the Macro is below but I am getting "Data >>> Type is not Supported". Anyone help with that. Also, another question >>> which may be simple sytax I do nto know, what is a good mechanism to break >>> out the SQL statments accross various lines instead of one line? >>> >>> BTW, using Excel 2010. >>> >>> Thanks In Advance. >>> >>> >>> Sub Get_Vessel_Schedule() >>> >>> Dim cn As ADODB.Connection >>> Dim rs As ADODB.Recordset >>> >>> Set cn = New ADODB.Connection >>> Set rs = New ADODB.Recordset >>> >>> cn.Open ( _ >>> "User ID=User" & _ >>> ";Password=Pass" & _ >>> ";Data Source=My DB" & _ >>> ";Provider=MSDAORA.1") >>> >>> rs.Open "select VESSEL.CODE, VESSEL.NAME, VV_VESSEL_VISIT.VESSEL_ID, >>> VV_VESSEL_VISIT.ARR_VOYAGE, VV_VESSEL_VISIT.DEP_VOYAGE, >>> VV_VESSEL_VISIT.BERTH, VV_VESSEL_VISIT.MPH, VV_VESSEL_VISIT.ESC_FORWARD_ >>> **DRAFT, VV_VESSEL_VISIT.ATA, VV_VESSEL_VISIT.ATD, VV_VESSEL_VISIT.ETA, >>> VV_VESSEL_VISIT.ETD from VV_VESSEL_VISIT join VESSEL on >>> VV_VESSEL_VISIT.VESSEL_ID=VESS**EL.ID <http://VESSEL.ID>", cn >>> >>> >>> Cells(6, 6).CopyFromRecordset rs >>> >>> End Sub >>> >>> >>> >> -- >> -- FORUM RULES (986+ 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 To >> unsubscribe, send a blank email to >> excel-macros+unsubscr...@googlegroups.com > > > > -- > David
Re: $$Excel-Macros$$ Re: MIS executive
I would appreciate if you could take the discussion about job postings off of the forum. Ayush has stated his decision regarding job postings as of now. As he mentioned, once this is allowed, people start abusing the option. That is why it has been banned. For job seekers, there are numerous job sites out there for Excel or related jobs. The volunteers here don't come here to see job ads, but to help others with solutions from their expertise and experience. As a member, I would only request everybody to keep the faith until Ayush figures out how this can be addressed. So PLEASE STOP PESTERING. Sam Mathai Chacko On Mon, Jun 18, 2012 at 11:25 PM, wrote: > ** > Hi Ayush, > > Why can't we have separate team of moderator like other sites. > > -- > *From: * Ayush Jain > *Sender: * excel-macros@googlegroups.com > *Date: *Mon, 18 Jun 2012 23:02:07 +0530 > *To: * > *ReplyTo: * excel-macros@googlegroups.com > *Subject: *Re: $$Excel-Macros$$ Re: MIS executive > > Hello All, > > Thank you for sharing your views. > > When I allowed the job posting earlier, people started posting all kind of > jobs. For me it is very difficult to moderate each job posts, and ban > people just because of job posting. > I will definitely think of channelising the job posts or add a link where > you can post the jobs. > > For now, Job posting is NOT allowed in forum. Let me know if you still > have any queries. > > Thanks and best regards > Ayush Jain > Group Manager > Microsoft MVP > > > On Mon, Jun 18, 2012 at 10:21 PM, yogananda muthaiah < > yogananda.mutha...@gmail.com> wrote: > >> Hi, >> >> Thank you everyone who has given a feedback to Ayush and he may come take >> this as +ve feedback. >> >> Please do call me if someone who is really looking for MIS profile and >> ready for face to face interview. >> >> >> >> On Mon, Jun 18, 2012 at 9:49 PM, pankaj gmail account < >> pankaji...@gmail.com> wrote: >> >>> Hi To All, >>> >>> I also agree that we should also think about Job Posting in this forum. >>> If a Needy gets Job with our help that's the best result of the forum. >>> >>> OK I also agree that this is not a Job Forum but instead of joining >>> other Job forums we should think some alternative like we can use some >>> Mandatory Subject Line etc JOB:- Posting :-- Job Details- >>> >>> >>> Dear Moderator Please think Excel do not pay much and now a days we are >>> facing lots of competition with other BI tools and i think excel should be >>> promoted more by sharing knowledge/jobs. >>> >>> >>> Thanks and Regards, >>> Pankaj >>> >>> >>> >>> >>> On Mon, Jun 18, 2012 at 4:08 PM, Mangesh Vimay >>> wrote: >>> >>>> Hi Friends, >>>> >>>> I am agree with Yogananda because many people are spending their time >>>> here to learn excel concepts with the intention to get the job and hence if >>>> someone is providing such nice opportunities then I think it is good. >>>> Moreover, only related job posting should be there (with excel, access >>>> only). >>>> >>>> Thanks. >>>> >>>> >>>> >>>> On Sun, Jun 17, 2012 at 8:04 AM, Prince Ever Increasing Abundance King >>>> of Exceeding Overflowing Prosperity wrote: >>>> >>>>> I have no intent of doing a job posting. Asking for others. >>>>> Where should job postings be done. I am in British Colulmbia Canada. >>>>> What should I do if I want to change to change my email receiving >>>>> address for this group? >>>>> >>>>> Thank you. >>>>> David >>>>> >>>>> -- >>>>> Date: Sat, 16 Jun 2012 08:14:00 -0700 >>>>> From: jainayus...@gmail.com >>>>> To: excel-macros@googlegroups.com >>>>> Subject: $$Excel-Macros$$ Re: MIS executive >>>>> >>>>> >>>>> Hi Yogananda, >>>>> >>>>> Please note that Job posting is allowed in this forum. Please do not >>>>> post any jobs going forward. >>>>> >>>>> Thanks. >>>>> >>>>> >>>>> On Saturday, 16 June 2012 16:41:50 UTC+5:30, (%Allmydreams%) wrote: >>>>> >>>>> Hi, >>>>> >>>
Re: $$Excel-Macros$$ Macro for column size reduction
You mean column width? Sam On Sun, Jun 17, 2012 at 2:38 PM, Amit Desai (MERU) wrote: > Dear Friends, > > ** ** > > Does anyone have a macro to reduce column size all together? > > ** ** > > Best Regards, > > Amit > > ** ** > > -- > Disclaimer: This message and its attachments contain confidential > information and may also contain legally privileged information. This > message is intended solely for the named addressee. If you are not the > addressee indicated in this message (or authorized to receive for > addressee), you may not copy or deliver any part of this message or its > attachments to anyone or use any part of this message or its attachments. > Rather, you should permanently delete this message and its attachments (and > all copies) from your system and kindly notify the sender by reply e-mail. > Any content of this message and its attachments that does not relate to the > official business of Meru Cab Company Pvt. Ltd. must be taken not to have > been sent or endorsed by any of them. Email communications are not private > and no warranty is made that e-mail communications are timely, secure or > free from computer virus or other defect. > > -- > FORUM RULES (986+ 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 > > To unsubscribe, send a blank email to > excel-macros+unsubscr...@googlegroups.com -- Sam Mathai Chacko -- FORUM RULES (986+ 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 To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com
Re: $$Excel-Macros$$ Find Narrow Cells & Appying Auto fit to only that cell
Should be *EntireColumns* as I had posted Regards, Sam Mathai Chacko On Sat, Jun 16, 2012 at 7:29 PM, dguillett1 wrote: > or > > ActiveSheet.UsedRange.Columns.AutoFit > > Don Guillett > Microsoft MVP Excel > SalesAid Software > dguille...@gmail.com > > *From:* Sam Mathai Chacko > *Sent:* Saturday, June 16, 2012 6:09 AM > *To:* excel-macros@googlegroups.com > *Subject:* Re: $$Excel-Macros$$ Find Narrow Cells & Appying Auto fit to > only that cell > > ActiveSheet.usedrange.entirecolumn.autofit > > Sam Mathai Chacko > > On Sat, Jun 16, 2012 at 4:28 PM, Rajan_Verma wrote: > >> Select the Column and press >> >> ALT + O C A >> >> >> >> ** >> >> *Regards* >> >> *Rajan verma* >> >> *+91 7838100659 [IM-Gtalk]* >> >> >> >> *From:* excel-macros@googlegroups.com [mailto: >> excel-macros@googlegroups.com] *On Behalf Of *Prashant Pawle >> *Sent:* 16 June 2012 1:40 >> *To:* excel-macros@googlegroups.com >> *Subject:* $$Excel-Macros$$ Find Narrow Cells & Appying Auto fit to only >> that cell >> >> >> >> Dear Team, >> >> >> >> Please help of some macro to find Narrow Cells & Appying Auto fit to only >> that cell , sample sheet attached >> >> >> >> Regards, >> >> >> >> Prashant >> >> -- >> -- FORUM RULES (986+ 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 To >> unsubscribe, send a blank email to >> excel-macros+unsubscr...@googlegroups.com >> -- >> FORUM RULES (986+ 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 >> >> To unsubscribe, send a blank email to >> mailto:excel-macros%2bunsubscr...@googlegroups.com >> > > > > -- > Sam Mathai Chacko > > -- > FORUM RULES (986+ 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 > > To unsubscribe, send a blank email to > excel-macros+unsubscr...@googlegroups.com >
Re: $$Excel-Macros$$ Find Narrow Cells & Appying Auto fit to only that cell
ActiveSheet.usedrange.entirecolumn.autofit Sam Mathai Chacko On Sat, Jun 16, 2012 at 4:28 PM, Rajan_Verma wrote: > Select the Column and press > > ALT + O C A > > ** ** > > * * > > *Regards* > > *Rajan verma* > > *+91 7838100659 [IM-Gtalk]* > > ** ** > > *From:* excel-macros@googlegroups.com [mailto: > excel-macros@googlegroups.com] *On Behalf Of *Prashant Pawle > *Sent:* 16 June 2012 1:40 > *To:* excel-macros@googlegroups.com > *Subject:* $$Excel-Macros$$ Find Narrow Cells & Appying Auto fit to only > that cell > > ** ** > > Dear Team, > > ** ** > > Please help of some macro to find Narrow Cells & Appying Auto fit to only > that cell , sample sheet attached > > ** ** > > Regards, > > ** ** > > Prashant > > -- > -- FORUM RULES (986+ 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 To > unsubscribe, send a blank email to > excel-macros+unsubscr...@googlegroups.com > > -- > FORUM RULES (986+ 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 > > To unsubscribe, send a blank email to > excel-macros+unsubscr...@googlegroups.com > -- Sam Mathai Chacko -- FORUM RULES (986+ 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 To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com
Re: $$Excel-Macros$$ Forum feature : Highlight code syntax
Nice one. It's about time they added this. Regards Sam On Thu, Jun 14, 2012 at 10:57 AM, Ayush Jain wrote: > Dear members, > > I would like to share one of the cool feature of new google groups. > This is called *'Highlight code syntax'* where you can highlight the code > in different color to normal content. This feature will distinguish your > code from your explanation of problem or solution. > It appears as right most option when you post using google groups. > <https://lh5.googleusercontent.com/-MXyhghaaziM/T9l1OYPeoVI/AWo/LKudJuFrQ5Q/s1600/highlight_code.JPG> > An example is given at the end. > > Please use this feature in your postings going forward. > > Thank you. > > Regards > Ayush Jain > Group Manager > www.discussexcel.com > > > > Sub Macro() > Msgbox "This is to highlight code syntax" > End Sub > > -- > FORUM RULES (986+ 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 > > To unsubscribe, send a blank email to > excel-macros+unsubscr...@googlegroups.com -- Sam Mathai Chacko -- FORUM RULES (986+ 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 To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com
Re: $$Excel-Macros$$ Forum feature : Highlight code syntax
Nice one. It's about time they added this. Regards Sam On Thu, Jun 14, 2012 at 10:57 AM, Ayush Jain wrote: > Dear members, > > I would like to share one of the cool feature of new google groups. > This is called *'Highlight code syntax'* where you can highlight the code > in different color to normal content. This feature will distinguish your > code from your explanation of problem or solution. > It appears as right most option when you post using google groups. > <https://lh5.googleusercontent.com/-MXyhghaaziM/T9l1OYPeoVI/AWo/LKudJuFrQ5Q/s1600/highlight_code.JPG> > An example is given at the end. > > Please use this feature in your postings going forward. > > Thank you. > > Regards > Ayush Jain > Group Manager > www.discussexcel.com > > > > Sub Macro() > Msgbox "This is to highlight code syntax" > End Sub > > -- > FORUM RULES (986+ 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 > > To unsubscribe, send a blank email to > excel-macros+unsubscr...@googlegroups.com -- Sam Mathai Chacko -- FORUM RULES (986+ 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 To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com
Re: $$Excel-Macros$$ Re: VLOOKUP FROM A RANGE OF SHEETS
YOu could use something like this
Use in B1 where you put the client name in A1
=INDEX(INDIRECT("'[sample file register
.xlsx]"&LEFT(A1,1)&"'!$A$2:$A$20"),MATCH(A1,INDIRECT("'[sample file
register .xlsx]"&LEFT(A1,1)&"'!$B$2:$B$20"),0))
Regards,
Sam Mathai Chacko
On Sat, Jun 9, 2012 at 5:06 PM, Vivek wrote:
>
> Dear All,
> Please find enclosed herewith the sample file.
> Thanks
> CA Vivek Jain.
>
> On Friday, 8 June 2012 10:12:45 UTC+5:30, Vivek wrote:
>
>> I have created a file index , with separate sheets alphabetically.
>>
>>
>>
>> Now I want to use the vlookup function in a new file, wherein I would
>> type the clients name , and it should lookup the file number from the index
>> file. Is it possible?
>>
>>
>>
>> Thanks & Regards...
>>
>> CA Vivek Jain, FCA, DISA (ICAI)
>>
>>
>>
> --
> FORUM RULES (986+ 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
>
> To unsubscribe, send a blank email to
> excel-macros+unsubscr...@googlegroups.com
--
Sam Mathai Chacko
--
FORUM RULES (986+ 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
To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com
Re: $$Excel-Macros$$ Rajan Verma - Most helpful Member(May'12)
Congratulations again Cheeteh great going. Regards, Sam Mathai Chacko On Mon, Jun 4, 2012 at 12:17 AM, wrote: > ** > Congratulation Raj. Proud of you. Lunch for you tommorrow. > Sent from my BlackBerry® smartphone from Airtel Ghana > -- > *From: * Ayush Jain > *Sender: * excel-macros@googlegroups.com > *Date: *Sun, 3 Jun 2012 23:12:31 +0530 > *To: *excel-macros > *ReplyTo: * excel-macros@googlegroups.com > *Subject: *$$Excel-Macros$$ Rajan Verma - Most helpful Member(May'12) > > Hello Everyone, > > Rajan Verma has been selected as 'Most Helpful Member' for the month of > May'2012 > He has posted 147 posts in May 2012 and helped many people through his > expertise. > > I truly appreciate his consistency and commitment to group. He is really > doing great job God bless you :) > > Thanks to Noorain, Don, Asa, Maries, and other folks for helping excel > enthusiasts voluntarily !! Keep it up !! > Trust me, It requires big heart to help others voluntarily and thanks to > everyone who is supporting this forum. > > Keep posting. > > Regards > Ayush Jain > Group Manager > Microsoft MVP > > -- > FORUM RULES (986+ 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 > > To unsubscribe, send a blank email to > excel-macros+unsubscr...@googlegroups.com > > -- > FORUM RULES (986+ 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 > > To unsubscribe, send a blank email to > excel-macros+unsubscr...@googlegroups.com > -- Sam Mathai Chacko -- FORUM RULES (986+ 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 To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com
Re: $$Excel-Macros$$ Chronos Twelve For Excel 2007
Ashish, Yes this can be used for Windows 7. The only reason I thought Windows 7 users may not find it too useful is because Windows 7 start menu already has similar features which helps in quickly opening recent files. No I haven't added a feature to delete history. For the time being, I think I should let people do that manually. But if there are requests from a people, I am happy to look at that also. This can be easily installed / uninstalled. All you need to do is go to Excel Options >> Add-Ins >> Manage Excel Add-Ins >> Go >> Browse and Select the File and click OK To uninstall, just come to the same browse window, and uncheck the add-in Regards, Sam Mathai Chacko On Wed, May 30, 2012 at 12:02 AM, Ashish Pradhan wrote: > > Hello Sam > > Haven't yet installed this tool. I use Windows 7 (and I believe this > wouldnt be applicable for windows 7). Have seen the screenshot. Looks good > but have a couple of perhaps stupid questions. > > 1. Can this file history be cleared ? > 2. Can this be un-installed ? (Which leads me to the very basic question > of how to install in the first place. Sorry, am a decent user of Office > Products, but not too advanced. This group goes a long way in enhancing my > skill sets though :-) ) > > Thanks > > Ashish Pradhan > > > On 29-05-2012 23:54, Sam Mathai Chacko wrote: > > Ever wished you could have all your recent Office files' MRU / Most > Recently Used / Recent link from Word, PowerPoint and Access in the same > place? Office 2010 has the recent folders list in the Backstage view. But > how about something similar in Excel 2007, especially with the Win XP, and > other pre-Windows 7 releases? > > *Chronos Twelve* (Chronos=Related to Time (recency); Twelve=Office > version 12.0) is an Excel based add-in that does just about this. This is > still in nascent stage of development, and I will add enhancements as and > when time permits. Feedback and suggestions are welcome. You might find a > bit odd behaviour with the recent files OR the recent folders list due to > some special characters that I may have missed out to include in the XML > parser. However, in most cases, this should work just fine. > > Also, since the MRU list for recent files in Excel 2007 will already be > visible in the default MRU list, I have not added this in the custom list > of this add-in. > > I would be more than glad to hear your feedback on this tool. > > Regards > Sam Mathai Chacko > -- > FORUM RULES (986+ 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 > > To unsubscribe, send a blank email to > excel-macros+unsubscr...@googlegroups.com > > -- > FORUM RULES (986+ 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 > > To unsubscribe, send a blank email to > excel-macros+unsubscr...@googlegroups.com > -- Sam Mathai Chacko -- FORUM RULES (986+ 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
Re: $$Excel-Macros$$ question for noorani
The link provided below has a lot to do with the CALL function which is not supported in latest versions of Excel. If you want to learn about XLM functions (Excel4), try this link which has an in-depth explanation of the GET.DOCUMENT and GET.CELL functions http://www.excelfox.com/forum/f13/excel-macro-functions-get-document-76/ http://www.excelfox.com/forum/f13/excel-macro-functions-get-cell-75/ Another example that uses GET.WORKBOOK http://www.excelfox.com/forum/f13/list-all-worksheet-names-using-formula-119/ Regards, Sam Mathai Chacko On Tue, May 29, 2012 at 4:20 PM, NOORAIN ANSARI wrote: > Dear Danial, > > Best Resource of Excel4 Function is : > > *http://www.cpearson.com/excel/Call.htm* > > > -- > Thanks & regards, > Noorain Ansari > www.noorainansari.com > www.excelmacroworld.blogspot.com > > > On Tue, May 29, 2012 at 3:35 PM, danial mansoor wrote: > >> how can we get excel 4 functions?any resource? >> >> >> >> -- >> Date: Tue, 29 May 2012 15:31:25 +0530 >> Subject: Re: $$Excel-Macros$$ MACRO >> From: noorain.ans...@gmail.com >> To: excel-macros@googlegroups.com >> >> Dear Sagar, >> >> Please find attached study material of Basic Macro and follow >> excel-macro group on regular basis. >> >> >> -- >> Thanks & regards, >> Noorain Ansari >> www.noorainansari.com >> www.excelmacroworld.blogspot.com >> >> On Tue, May 29, 2012 at 2:28 PM, SAGAR KASANGOTTUWAR < >> sagarkasangottu...@gmail.com> wrote: >> >> Dear All, >> >> I want to learn MACRO's from basic so kindly give me some material for >> the same. >> >> >> Thanks & Regards, >> >> K SAGAR >> >> -- >> FORUM RULES (986+ 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 >> >> To unsubscribe, send a blank email to >> excel-macros+unsubscr...@googlegroups.com >> >> >> >> >> >> >> >> >> -- >> FORUM RULES (986+ 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 >> >> To unsubscribe, send a blank email to >> excel-macros+unsubscr...@googlegroups.com >> >> -- >> FORUM RULES (986+ 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 >> si
Re: $$Excel-Macros$$ Urgent Client Position ::: Java Flex Developer - Work Location: Palo Alto, CA
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 > > > > To unsubscribe, send a blank email to > excel-macros+unsubscr...@googlegroups.com > > -- > FORUM RULES (986+ 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 > > To unsubscribe, send a blank email to > excel-macros+unsubscr...@googlegroups.com > -- Sam Mathai Chacko -- FORUM RULES (986+ 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 To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com
Re: $$Excel-Macros$$ Urgent Client Position :: Messaging Engineer with EMA & PG Messaging -- Work Location :: Parsippany NJ or Collegeville PA
) 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 > > To unsubscribe, send a blank email to > excel-macros+unsubscr...@googlegroups.com -- Sam Mathai Chacko -- FORUM RULES (986+ 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 To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com
Re: $$Excel-Macros$$ Urgent Client Position :: Java Developer - Work Location: Madison, WI
Please adhere to the forum rules. Job posting has been strictly discouraged by the forum manager. Sam On Wed, May 23, 2012 at 9:48 PM, sai girish wrote: > *Hi,* > > *This is Thomas Fedrick, - Recruitment and Resources from SancroSoft USA > Inc.* > > We have an urgent requirement as follows: > > Please reply to this email with the latest copy of your resume in MS-Word > Format with the following details to > *tho...@sancrosoftusa.com* > > Full Name : > Location : > Contact Number : > Email : > Availability : > Rate / Hour : > Visa Status : > > *Requirement Details** :--* > > *Job Code : 157621* > > *Java Developer* > > Work Location: Madison, WI > Duration : 3-6 Months+ Contract > > Rate: $40/hr C2C Max > > Client : Wipro > > Note : Any Visa Status is fine > > Basic Java Developer > > Good Experience in Java/ J2EE is required > > Total of 4+ years of experience. > > > > > > > > *Thanks & Regards* > > *Thomas Fedrick** > **Recruiting Specialist "IT Services"* > > *[image: Description: Description: Description: Description: Description: > Description: cid:image001.jpg@01CD14F0.B169F430] [image: Description: > Description: Description: Description: Description: Description: > cid:image002.jpg@01CD14F0.B169F430] * > > * **The power of focus* > > *SancroSoft USA INC* > > *4944 Sunrise Blvd, Suite B-4 || Fair Oaks, CA 95628 > Phone : 916-671-5559* ||* 916-671-5584 *||* Fax: 916-200-0305* > *E-Mail :* *tho...@sancrosoftusa.com* || * > www.sancrosoftusa.com* <http://www.sancrosoftusa.com/> > * > We place professionals in contract, contract-to-hire and full-time > employment positions * > > *across all IT and Engineering disciplines, **nationwide* > > Stay Connected: > > [image: Description: Description: Description: Description: Description: > Description: > cid:image003.png@01CD14F0.B169F430]<http://www.linkedin.com/in/Thomasfedrick> > > [image: Description: Description: Description: Description: Description: > Description: > cid:image004.png@01CD14F0.B169F430]<http://www.facebook.com/people/Thomas-Fedrick/10156958548> > > [image: Description: Description: Description: Description: Description: > Description: > cid:image005.png@01CD14F0.B169F430]<https://twitter.com/#%21/thomasfedrick99> > > For More Job Openings , Please Visit my blog [image: Description: > Description: Description: Description: Description: Description: > http://t0.gstatic.com/images?q=tbn:ANd9GcTtrxGMSDzmqNcd78ZgJEjlJHrdvfl3wZ7N2W02bC6UwOEQJQUO]<http://thomassancrosoftusa.blogspot.in/> > > The information contained in this email message is intended only for the > personal and confidential use of the recipient(s) named above. The message > may be privileged and confidential and protected from disclosure. If the > reader of this message is not the intended recipient or an agent > responsible for delivering it to the intended recipient, you are hereby > notified that you have received this document in error and that any review, > dissemination, distribution, copying of this message is strictly > prohibited. If you have received this communication in error, please notify > us immediately by email and delete the original message. > > -- > FORUM RULES (986+ 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 > > To unsubscribe, send a blank email to > excel-macros+unsubscr...@googlegroups.com -- Sam Mathai Chacko -- FORUM RULES (986+ 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 mea
Re: $$Excel-Macros$$ Apportioned of Expenses
Here's one with SUMIF Regards, Sam Mathai Chacko On Fri, May 18, 2012 at 9:22 AM, Ashish Pradhan wrote: > > Hello > > Was trying to understand and learn the formula used by Ashish Koul. > > However, when I edit the formula and exit the formula bar (without making > any changes), I get #Name? as the result. > > I would assume that is has something to do with _xlfn.Sumifs used in the > formula and Excel 2003 (Sp3) that I use. > > Can anyone help with using the same sheet with formulae for Excel 2003 (If > thats why I am getting the #Name? error) > > Thanks > > Ashish Pradhan > > > On 18-05-2012 19:07, ashish koul wrote: > > see if it helps > > On Fri, May 18, 2012 at 6:20 PM, dguillett1 wrote: > >> Put in J5 and drag across and down >> =IF(E5<>"yes","",$C5/SUMPRODUCT(($E5:$H5="yes")*$E$3:$H$3)*E$3) >> >> Don Guillett >> Microsoft MVP Excel >> SalesAid Software >> dguille...@gmail.com >> >> *From:* Sandeep Chhajer >> *Sent:* Friday, May 18, 2012 5:04 AM >> *To:* excel-macros@googlegroups.com >> *Subject:* $$Excel-Macros$$ Apportioned of Expenses >> >>Dear Excel Guru, >> >> Please find the attheche file. >> >> >> >> >> No of Student >> >> >> >> >> >> >> FSLE FSB FSC FSPA Total My Ans should be >> >> >> >> >> 25 13 40 10 88 Result required EXP Amount >> >> >> >> >> >> FSLE FSB FSC FSPA Printing 23,456 >> Yes Yes Yes Yes >> 6,664 3,465 10,662 2,665 Fees >> 344,567 >> >> Yes Yes >> >>84,516260,051Salary 2,345,098 >> >> >> Yes >> >> 2,345,098other 56,743 >> >> Yes >> Yes >>32,072 24,671 >> >> >> >> >> >> >> >> Expenses needs to be apportined with respect to yes written adjoing col. >> >> >> >> -- >> Regards, >> Sandeep Kumar Chhajer. >> Ph. no: 07498171901 >>09339549906 >> >> Wish you all happy new Year 2011. >> >> -- >> FORUM RULES (986+ 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 (986+ 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 >> > > > > -- > *Regards* > * * > *Ashish Koul* > *http://www.excelvbamacros.com/* > *http://www.accessvbamacros.com/* <http://www.accessvbamacros.com/> > > > P Before printing, think about the environment. > > > -- > FORUM RULES (986+ members already BANNED for violation) > > 1) Use concise, accurate thread
Re: $$Excel-Macros$$ Passing Values Between UserForms
This is one way to do it. Run UserForm1 first.
Regards
Sam Mathai Chacko
On Fri, May 11, 2012 at 3:14 PM, Shekhar Sharma wrote:
> Is it possible to pass Values between UserForms? If so, what's the syntax
> for doing it?
> Let's say I'm using this code
>
>>
>
> Private Sub CmdContinue_Click()
>Dim ws As Worksheet, sWCat1 As Range, sWCat2 As Range, Checker
>Set ws = Worksheets("Categories")
>Set Checker = 0
>For Each sWCat1 In ws.Range("A47:A53")
> If sWCat1.Value = "Select" Then
> MsgBox "Error 009: Weapon Skill Category Not Selected"
> Checker = 1
> End If
> For Each sWCat2 In ws.Range("A47:A53")
> If sWCat1.Value = sWCat2.Value Then
> MsgBox "Error 010: Weapon Skill Categories Cannot Be Repeated"
> Checker = 1
> End If
> Next sWCat2
> If sWCat1.Offset(0, 1).Value <> 0 Then
> Load CtrlCreate3A
> Me.Hide
> CtrlCreate3A.Show
> Checker = 1
> End If
>Next sWCat1
>If Checker <> 0 Then
> End
>Else
> Load CtrlCreate4
> Me.Hide
> CtrlCreate4.Show
> Unload Me
>End If
> End Sub
>
>
> Ideally I'd like to be able to pass the value of sWCat1.Value into
> UserForm CtrlCreate3A.
>
> --
> Shekhar Sharma
> 9910010060
> "Life consists not in holding good cards but in playing
> those you hold well"
> "Before you judge another, think of your own last mistake."
>
> --
> FORUM RULES (986+ 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
>
--
Sam Mathai Chacko
--
FORUM RULES (986+ 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
Pass Value From One UserFrom To Other.xlsm
Description: Binary data
Re: $$Excel-Macros$$ Date Problem
Because today is the 5th month. And the value of 5 is actually equivalent to 5 days starting from day zero. In other words, it is just the 5th of January 1900. And the month of 5th January 1900 is "Jan" of course. Regards, Sam Mathai Chacko On Tue, May 8, 2012 at 11:33 AM, wrote: > ** > Thanks for this as well Noorain. But can you explain why excel was > returning Jan when I tried ♍Ɣ earlier formula? Just for ♍Ɣ information. > Thnks > Sent from my BlackBerry® smartphone from Airtel Ghana > -- > *From: * NOORAIN ANSARI > *Sender: * excel-macros@googlegroups.com > *Date: *Tue, 8 May 2012 23:58:01 +0530 > *To: * > *ReplyTo: * excel-macros@googlegroups.com > *Subject: *Re: $$Excel-Macros$$ Date Problem > > Another approach.. > > * > =CHOOSE(MONTH(TODAY()),"Jan","Feb","Mar","Apr","May","Jun","Jul","Aug","Sep","Oct","Nov","Dec") > * > > -- > Thanks & regards, > Noorain Ansari > www.noorainansari.com > www.excelmacroworld.blogspot.com > > On Tue, May 8, 2012 at 11:32 PM, hilary lomotey wrote: > >> Hello >> >> Pls i want to get the month of today such as May but if i use this >> formula TEXT(MONTH(TODAY()),"mmm") its evaluates to Jan, however if i >> evaluate only MONTH(TODAY()) is gets the correct month which is 5, so why >> am i getting Jan, when i add the text fucntion. >> >> i need it to be dynamic, thats why i want to use today >> >> >> -- >> FORUM RULES (986+ 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 (986+ 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 (986+ 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 > -- Sam Mathai Chacko -- FORUM RULES (986+ 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
Re: $$Excel-Macros$$ Date Problem
Just Use =TEXT(TODAY(),"mmm") Regards, Sam Mathai Chacko On Tue, May 8, 2012 at 11:02 AM, hilary lomotey wrote: > Hello > > Pls i want to get the month of today such as May but if i use this > formula TEXT(MONTH(TODAY()),"mmm") its evaluates to Jan, however if i > evaluate only MONTH(TODAY()) is gets the correct month which is 5, so why > am i getting Jan, when i add the text fucntion. > > i need it to be dynamic, thats why i want to use today > > > -- > FORUM RULES (986+ 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 > -- Sam Mathai Chacko -- FORUM RULES (986+ 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
Re: $$Excel-Macros$$ Rajan verma : Most Helpful Member- Apr'2012
Congrats Cheetah Regards, Sam On Wed, May 2, 2012 at 10:04 PM, NOORAIN ANSARI wrote: > यूँ ही बरकरार रखो भाई अपने Expertise के छाप को. > और अपनी तरक्की से छोटा कर दो आसमा के माप को. > हम दोस्तों की दुआए,छोड़े ना हरगिज़ साथ, > मेरे ओर से लाख-लाख बधाई, राजन बाबु आपको. > > -- > Thanks & regards, > Noorain Ansari > www.noorainansari.com > www.excelmacroworld.blogspot.com > > On Wed, May 2, 2012 at 9:30 PM, Ayush Jain wrote: > >> Hello Everyone, >> >> Rajan Verma has been selected as 'Most Helpful Member' for the month of >> April'2012 >> He has posted 185 posts in April 2012 and helped many people through his >> expertise. He has been consistent contributor to this excel forum and has >> acheived this recognition many times. >> >> Thanks to Don, Noorain, Asa, Maries, and other folks for helping excel >> enthusiasts voluntarily !! Keep it up !! >> >> Keep posting. >> >> Regards >> Ayush Jain >> Group Manager >> Microsoft MVP >> >> -- >> FORUM RULES (986+ 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 (986+ 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 > -- Sam Mathai Chacko -- FORUM RULES (986+ 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
Re: $$Excel-Macros$$ Macro coding
What do you mean by appropriate code? Regards, Sam On Sat, Apr 28, 2012 at 3:42 PM, Deba Ranjan wrote: > *Hi sir, > >I tried many times but the coding never comes, i mean the appropriate > coding never comes. kindly sort out. > * > > > > Thanks & Regards,* > * > > *Deba Ranjan P*** > > **** > > > On Sat, Apr 28, 2012 at 2:17 PM, Sam Mathai Chacko wrote: > >> You can record macros in Excel. To know how to record macros, just do a >> google search. >> >> REgards, >> Sam Mathai Chack >> >> >> On Sat, Apr 28, 2012 at 1:42 PM, Deba Ranjan wrote: >> >>> *Hi Experts, >>> >>> Is there any trick or any software to create macros coding. i have >>> seen many from the experts that they easily run the macros with the coding. >>> Please do let me the prevailing coding how to write the coding. >>> * >>> >>>Thanks in advance. Hope you all help me out for the coding. >>> >>> >>> Thanks & Regards,* >>> * >>> >>> *Deba Ranjan P*** >>> >>> -- >>> FORUM RULES (986+ 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 >>> >> >> >> >> -- >> Sam Mathai Chacko >> >> -- >> FORUM RULES (986+ 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 (986+ 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 > -- Sam Mathai Chacko -- FORUM RULES (986+ 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
Re: $$Excel-Macros$$ Macro coding
You can record macros in Excel. To know how to record macros, just do a google search. REgards, Sam Mathai Chack On Sat, Apr 28, 2012 at 1:42 PM, Deba Ranjan wrote: > *Hi Experts, > > Is there any trick or any software to create macros coding. i have seen > many from the experts that they easily run the macros with the coding. > Please do let me the prevailing coding how to write the coding. > * > >Thanks in advance. Hope you all help me out for the coding. > > > Thanks & Regards,* > * > > *Deba Ranjan P*** > > -- > FORUM RULES (986+ 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 > -- Sam Mathai Chacko -- FORUM RULES (986+ 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
Re: $$Excel-Macros$$ Happy Birth Day Ayush.
Happy Birthday Ayush. Have a great new year. REgards, Sam Mathai CHacko On Fri, Apr 27, 2012 at 3:24 AM, Michael Brumby wrote: > *Happy birthday...!!* > > Best Regards. > Mr Michael Brumby > Diese Email und samtliche beigefugten Anhange sind vertraulich zu > behandeln und sind vor Veroffentlichung geschutzt. Informieren Sie den > Absender bitte umgehend und loschen Sie diese Nachricht mit allen > beigefugten Anhangen, falls Sie nicht der vorgesehene Empfanger sind. Der > Inhalt dieser Email darf nicht an oder von dritten weitergeleitet, > veroffentlicht, verwendet, oder kopiert werden, oder durch jegliches Medium > gespeichert werden. > > > --- On *Thu, 26/4/12, Aruna jayaram * wrote: > > > From: Aruna jayaram > Subject: Re: $$Excel-Macros$$ Happy Birth Day Ayush. > To: excel-macros@googlegroups.com > Date: Thursday, 26 April, 2012, 6:49 > > > many happy returns for the day ayush > On Apr 26, 2012 11:13 AM, "bhupendra singh raghav" < > raghav.bhupen...@gmail.com<http://uk.mc1612.mail.yahoo.com/mc/compose?to=raghav.bhupen...@gmail.com>> > wrote: > > Hi Ayush, > > > > Many many happy returns of the day. > > > > > > > > Regards > > Raghav > -- > FORUM RULES (986+ 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<http://uk.mc1612.mail.yahoo.com/mc/compose?to=excel-macros@googlegroups.com> > > -- > FORUM RULES (986+ 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 (986+ 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 > -- Sam Mathai Chacko -- FORUM RULES (986+ 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
Re: $$Excel-Macros$$ What is left behind when you clear or delete cell contents that still affects usedrange?
This might be of interest http://www.excelfox.com/forum/f22/replacement-flawed-usedrange-property-374/ Regards, Sam Mathai Chacko On Thu, Apr 19, 2012 at 5:22 AM, Domain Admin wrote: > Actually ever weirder. If I keep clearing the current region and > pasting in the exact same > data over and over the usedrange number of rows increases by 1 each time. > > On Wed, Apr 18, 2012 at 4:41 PM, Domain Admin > wrote: > > Sorry Don but I can not comply with your request in this case easily. > > But I will get there if needed. > > > > Asa what you said tells me that what I am doing should work. At the > > time I clear the contents > > of the currentrengion is has fewer columns than usedrange but exactly > > the same number of rows. > > > > After clearing or deleting the contents of currentregion and then > > loading in a new set of data > > with fewer rows than before, the row count of usedrange is still the > > same as before. > > > > On Wed, Apr 18, 2012 at 4:25 PM, Asa Rossoff wrote: > >> UsedRange includes the intersection of all rows with used cells and all > >> columns with used cells. In other words, UsedRange is always a > rectangular > >> range. > >> > >> > >> > >> CurrentRegion based on a cell with a value in it also returns a > rectangular > >> range. RANGE.CurrentRegion returns a RANGE that includes the specified > >> RANGE and that is bounded by a completely empty row on top and bottom, > and a > >> completely empty column on left and right. > >> > >> > >> > >> Asa > >> > >> > >> > >> -Original Message- > >> From: excel-macros@googlegroups.com [mailto: > excel-macros@googlegroups.com] > >> On Behalf Of Domain Admin > >> Sent: Wednesday, April 18, 2012 4:12 PM > >> To: excel-macros@googlegroups.com > >> Subject: Re: $$Excel-Macros$$ What is left behind when you clear or > delete > >> cell contents that still affects usedrange? > >> > >> > >> > >> Deleting the columns from row 2 (save the header row) to xldown and > >> > >> shifting cells up does not solve it. > >> > >> > >> > >> On Wed, Apr 18, 2012 at 4:04 PM, Domain Admin > wrote: > >> > >>> Never mind about the ROUND part. It returns 0 for a truly empty cell. > >> > >>> > >> > >>> On Wed, Apr 18, 2012 at 4:01 PM, tangledweb > wrote: > >> > >>>> I am doing many tests on columns of date pasted into a sheet. > Sometimes > >> > >>>> more rows, sometimes less. > >> > >>>> It is important that I be able to define the working range as just > what > >>>> has > >> > >>>> data in it. However when I use > >> > >>>> clear or delete on the usedrange or currentregion or any other way to > >>>> define > >> > >>>> it everything seems to be gone > >> > >>>> but there is something left behind that is part of usedrange. The > only > >>>> way > >> > >>>> I have found to make this work > >> > >>>> is to delete the entire row which deletes other stuff I want to > keep. Is > >> > >>>> there really no way to truly empty > >> > >>>> the cells? Side not the ROUND function running on those cells puts > in a > >>>> 0 > >> > >>>> > >> > >>>> -- > >> > >>>> FORUM RULES (986+ 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 >
Re: $$Excel-Macros$$ CommandText Refresh does not change criteria in Excel 2007 VBA
Nothing obvious. Can you share the original query with the datevariable, and what is the new value that gets stored in the strNewCmd variable? Regards, Sam Mathai Chacko On Thu, Apr 19, 2012 at 1:35 AM, JB wrote: > I have Excel 2010 on Windows 7. I wrote a code to dynamically open a > pre-existing ODC file which has certain specific details to Connect to OLAP > Cube. Once open, I use code to update the CommandText to allow some basic > variation to date change. Once updated the text, I do > OLEDBConnection.Refresh.. It works fine on my machine where I have Excel > 2010. However, I gave this code to someone in team who has Excel 2007 and > regardless of any change that he makes to bring custom dates, he only gets > what's in the pre-existing ODC file. Code snippet is.. > > Set objFile = Application.Workbooks.Open(strSrcFile) > strNewCmd = Replace(strQry, "_DATEVARIABLE_", iDtReq) > objFile.Connections.Item(1).OLEDBConnection.CommandText = strNewCmd > objFile.Connections.Item(1).OLEDBConnection.BackgroundQuery = False > objFile.Connections.Item(1).OLEDBConnection.Refresh > > > Ideally, this code allows user to get historical data... Other parameters > do not change . At least what we have found is this problem is isolated to > Excel 2007 only... Does anyone have any suggestion as to what might be > wrong ? Thanks J > > -- > FORUM RULES (986+ 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 > -- Sam Mathai Chacko -- FORUM RULES (986+ 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
Re: $$Excel-Macros$$ Quarter Classification
A shorter one =CHOOSE(CEILING(MONTH(A1)/3,1),"April","July","October","January") Regards, Sam On Sat, Apr 14, 2012 at 6:19 PM, Nikhil Shah wrote: > Hi Maries, > > Thanks for solving my problem. > > Nikhil > > On Sat, Apr 14, 2012 at 6:15 PM, dguillett1 wrote: > >> You need to provide a file. >> >> Don Guillett >> Microsoft MVP Excel >> SalesAid Software >> dguille...@gmail.com >> >> *From:* Nikhil Shah >> *Sent:* Saturday, April 14, 2012 2:38 AM >> *To:* excel-macros@googlegroups.com >> *Subject:* $$Excel-Macros$$ Quarter Classification >> >> Dear Friends, >> >> I want to make the whole year classified in to 4 quarters as January, >> April, July and October. >> >> As and when I give a date it should be grouping in to that particular >> quarter only,( the date may be random) and one more thing that the very >> next Quarter will be taken for the name printing and followed by next >> remaining quarters. >> >> Ex : [ 1 ]. If I give a date - 16/08/2009 (dd/mm/) the whole process >> will be like , Quarter grouping as 3rd Quarter as July Quarter and out put >> name will be printed as October ( the very next Quarter) then followed by >> Jan, April, and July. >> >> Ex : [ 2 ]. Date.15/12/2010 (dd/mm/) Quarter will be - October >> and the print will be January, April, July and October >> >> Ex : [ 3 ] . Date.22/03/2011 (dd/mm/) Quarter will be - January >> and the print will be April,July and October and January. >> >> Ex : [ 4 ]. Date.15/10/2008 (dd/mm/) Quarter will be - October >> and the print will be January, April,July and october >> >> I am using Excel 2003. I do want any Macro , I want Only Formula >> >> Awaiting Reply >> >> Nikhil Shah >> -- >> FORUM RULES (986+ 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 (986+ 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 (986+ 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$$ Hash Hash appearing in formula
Custom format the cell to "0" Regards, Sam On Sat, Apr 14, 2012 at 6:16 PM, hilary lomotey wrote: > Hello Experts > > Attached is a call report i have created. Where you can choose a > department from the drop down and see the call report for that dept. The > problem am facing is that some of the words typed into the discussion > details are very long so when you choose that particular client name it > shows only hash hash. i tried word wrap or insert the Char 10 function but > its not working , pls help. thanks > > -- > FORUM RULES (986+ 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 > -- Sam Mathai Chacko -- FORUM RULES (986+ 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 call report.xlsx Description: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet
Re: $$Excel-Macros$$ Most helpful Member - March 12- Don Guillett
Donald, your presence here is a boon to many. From everyone who has benefited from your expertise, one way or the other, a big thanks. And congratulations. Regards, Sam Mathai Chacko On Sat, Apr 14, 2012 at 4:19 PM, wrote: > ** > Congrats Don n Thanks a lot for sharing. > -- > *From: * Ayush Jain > *Sender: * excel-macros@googlegroups.com > *Date: *Sat, 14 Apr 2012 09:36:16 +0100 > *To: *excel-macros > *ReplyTo: * excel-macros@googlegroups.com > *Subject: *$$Excel-Macros$$ Most helpful Member - March 12- Don Guillett > > Dear members, > > Don Guillett has been selected as 'Most Helpful Member' for the month of > March'12 > He has been helping forum members from long time consistently and we are > proud to have him in the forum. > > He is business degree holder from University of Texas and retired Regional > Manager for ING. > > Don, Many Many Thanks for your great contribution to forum. > > Keep Posting !! > > Best regards, > Ayush Jain > Group Manager, Microsoft MVP > > -- > FORUM RULES (986+ 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 (986+ 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 > -- Sam Mathai Chacko -- FORUM RULES (986+ 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
Re: $$Excel-Macros$$ Index function help needed
Check attached REgards, Sam Mathai Chacko On Sat, Apr 14, 2012 at 3:52 AM, Mr Excellent wrote: > Hi All, > > Need a simple index function with a drop given to auto publish the values > in the given table > > Please help > > Thanks > Excellent > > -- > FORUM RULES (986+ 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 > -- Sam Mathai Chacko -- FORUM RULES (986+ 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 Book2 (Autosaved).xlsx Description: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet
Re: $$Excel-Macros$$ How to Delete End (Shift Enter) - Macro Needed
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 (986+ 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 > -- Sam Mathai Chacko -- FORUM RULES (986+ 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
Re: $$Excel-Macros$$ Looking for Excel/Access vba job with 6 years of experience
Kavita, I am looking for such a person. I'm sure you remember me from good old days. Regards, Sam On Tue, Apr 3, 2012 at 6:35 PM, kavita ahuja wrote: > Hi Friends, > > I am looking for a job in excel/Access vba with 6 years experience in > gurgaon. > Please contact me if you know about any opening in gurgaon. > > Would appreciate your help. > > > > Many thanks , > Kavita > > -- > FORUM RULES (986+ 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 > -- Sam Mathai Chacko -- FORUM RULES (986+ 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
Re: $$Excel-Macros$$ Add-in creation in excel 2007
The Custom UI Editor Tool is used to modify the XML tag of the custom UI xml files on an office application file like Excel,Word, PPT, etc. Quite a few examples can be found at http://www.excelfox.com/forum/f10/ Regards, Sam Mathai Chacko On Tue, Apr 3, 2012 at 1:23 AM, Maries wrote: > Hi Raj, > > Check below link, > > http://jackmcintyre.net/how-to-add-macros-to-the-excel-2007-ribbon/ > > Dear Friends, > > Anyone give more details about Custom UI Editor > Tool<http://openxmldeveloper.org/articles/CustomUIeditor.aspx>. > From above link, I came to know we required Custom UI Editor > Tool<http://openxmldeveloper.org/articles/CustomUIeditor.aspx>for customize > the Ribbon. > > Regards, > > MARIES. > > > On Mon, Apr 2, 2012 at 10:10 PM, Rajan_Verma wrote: > >> I think u should create custom menu to display that in Ribbon >> >> ** ** >> >> Rajan >> >> ** ** >> >> *From:* excel-macros@googlegroups.com [mailto: >> excel-macros@googlegroups.com] *On Behalf Of *Raj Mahapatra >> *Sent:* Apr/Mon/2012 11:30 >> >> *To:* excel-macros@googlegroups.com >> *Subject:* Re: $$Excel-Macros$$ Add-in creation in excel 2007 >> >> ** ** >> >> ** ** >> >> sam, how would i get that add in as a tab in ms excel >> >> Thanks & Regards >> >> ** ** >> >> Rajesh Mahapatra >> >> ** ** >> >> ** ** >> >> On Mon, Apr 2, 2012 at 10:57 PM, Sam Mathai Chacko >> wrote: >> >> Add-ins are designed to run in the background, and hence the file will >> not be visible when you open it. If you go to the VBE window, you could >> actually see that the vba project for your add-in is shown. >> Sam Mathai Chacko >> >> ** ** >> >> On Mon, Apr 2, 2012 at 10:50 PM, Raj Mahapatra >> wrote: >> >> hi group, >> >> ** ** >> >> i wants to create addin in excel. i have created a addin using below >> steps, but it is not working. >> >> ** ** >> >> 1. in new workbook, i have insert a module and macro codes in it. >> >> 2. then saved the same workbook using ".xlam" extension. >> >> 3. when i opens the same add in in new excel. it does not open. >> >> ** ** >> >> appreciation for your assistance. >> >> ** ** >> >> thanks & regards >> >> ** ** >> >> Rajesh Mahapatra >> >> -- >> FORUM RULES (986+ 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 >> >> >> >> >> >> -- >> Sam Mathai Chacko >> >> ** ** >> >> -- >> FORUM RULES (986+ 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@googlegroup
Re: $$Excel-Macros$$ Add-in creation in excel 2007
This link will tell you how to add a tab in Excel http://www.excelfox.com/forum/f10/how-add-new-ribbon-tab-excel-26/?highlight=ribbon Regards, Sam Mathai Chacko On Mon, Apr 2, 2012 at 11:40 PM, Rajan_Verma wrote: > I think u should create custom menu to display that in Ribbon > > ** ** > > Rajan > > ** ** > > *From:* excel-macros@googlegroups.com [mailto: > excel-macros@googlegroups.com] *On Behalf Of *Raj Mahapatra > *Sent:* Apr/Mon/2012 11:30 > > *To:* excel-macros@googlegroups.com > *Subject:* Re: $$Excel-Macros$$ Add-in creation in excel 2007 > > ** ** > > ** ** > > sam, how would i get that add in as a tab in ms excel > > Thanks & Regards > > ** ** > > Rajesh Mahapatra > > ** ** > > ** ** > > On Mon, Apr 2, 2012 at 10:57 PM, Sam Mathai Chacko > wrote: > > Add-ins are designed to run in the background, and hence the file will not > be visible when you open it. If you go to the VBE window, you could > actually see that the vba project for your add-in is shown. > Sam Mathai Chacko > > ** ** > > On Mon, Apr 2, 2012 at 10:50 PM, Raj Mahapatra > wrote: > > hi group, > > ** ** > > i wants to create addin in excel. i have created a addin using below > steps, but it is not working. > > ** ** > > 1. in new workbook, i have insert a module and macro codes in it. > > 2. then saved the same workbook using ".xlam" extension. > > 3. when i opens the same add in in new excel. it does not open. > > ** ** > > appreciation for your assistance. > > ** ** > > thanks & regards > > ** ** > > Rajesh Mahapatra > > -- > FORUM RULES (986+ 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 > > > > > > -- > Sam Mathai Chacko > > ** ** > > -- > FORUM RULES (986+ 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 (986+ 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 (986+ members already BANNED for violation) > > 1) Use concise, accurate thread titles. Poor thread
Re: $$Excel-Macros$$ Add-in creation in excel 2007
Add-ins are designed to run in the background, and hence the file will not be visible when you open it. If you go to the VBE window, you could actually see that the vba project for your add-in is shown. Sam Mathai Chacko On Mon, Apr 2, 2012 at 10:50 PM, Raj Mahapatra wrote: > hi group, > > i wants to create addin in excel. i have created a addin using below > steps, but it is not working. > > 1. in new workbook, i have insert a module and macro codes in it. > 2. then saved the same workbook using ".xlam" extension. > 3. when i opens the same add in in new excel. it does not open. > > appreciation for your assistance. > > thanks & regards > > Rajesh Mahapatra > > -- > FORUM RULES (986+ 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 > -- Sam Mathai Chacko -- FORUM RULES (986+ 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
Re: $$Excel-Macros$$ help
Errr... not sure what you meant by that. Like I said, it just means that
all range of cells in Column D that are blank gets collected (set) in that
range variable.
Sam
On Sat, Mar 31, 2012 at 11:11 PM, vijayajith VA wrote:
>
> Thanks sam
>
> means same range suppose a1(blank cell) will search for a1 in other
> workbook & get filled rite...
>
>
> On Sat, Mar 31, 2012 at 10:43 PM, Sam Mathai Chacko wrote:
>
>> It means that all blank cells from Column D are being set to that range
>> variable
>>
>> Regards,
>> Sam Mathai Chacko
>>
>>
>> On Sat, Mar 31, 2012 at 10:38 PM, vijayajith VA
>> wrote:
>>
>>> Hi,
>>>
>>> Set sourcerange = Columns("D").SpecialCells(xlCellTypeBlanks)
>>>
>>> Can any one explain above code?
>>> what does it mean?
>>>
>>> Thanks in advance
>>>
>>> --
>>> FORUM RULES (986+ 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
>>>
>>
>>
>>
>> --
>> Sam Mathai Chacko
>>
>> --
>> FORUM RULES (986+ 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 (986+ 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
>
--
Sam Mathai Chacko
--
FORUM RULES (986+ 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
Re: $$Excel-Macros$$ help
It means that all blank cells from Column D are being set to that range
variable
Regards,
Sam Mathai Chacko
On Sat, Mar 31, 2012 at 10:38 PM, vijayajith VA wrote:
> Hi,
>
> Set sourcerange = Columns("D").SpecialCells(xlCellTypeBlanks)
>
> Can any one explain above code?
> what does it mean?
>
> Thanks in advance
>
> --
> FORUM RULES (986+ 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
>
--
Sam Mathai Chacko
--
FORUM RULES (986+ 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
Re: $$Excel-Macros$$ Macro for 100 sheets
I'd keep it short like this
Sub SheetAd()
Dim l As Long
For l = 1 To 100
Sheets("Sheet1").Copy , ActiveSheet
Next
End Sub
REgards
Sam Mathai Chacko
On Sat, Mar 31, 2012 at 1:11 PM, Asa Rossoff wrote:
> Sorry, Sandeep, I did not immediately see that you needed copies of another
> sheet. Maries has you.
>
> Asa
>
> -Original Message-
> From: Asa Rossoff [mailto:a...@lovetour.info]
> Sent: Saturday, March 31, 2012 12:40 AM
> To: 'excel-macros@googlegroups.com'
> Subject: RE: $$Excel-Macros$$ Macro for 100 sheets
>
> Hi Sandeep,
>
> sheets.Add count:=100
>
> Check help for additional options.
> Asa
>
> -Original Message-
> From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
> On Behalf Of chhajersand...@gmail.com
> Sent: Friday, March 30, 2012 11:11 PM
> To: excel-macros@googlegroups.com
> Subject: $$Excel-Macros$$ Macro for 100 sheets
>
> Dear excel guru,
>
> I want a macro to insert 100 sheets (all are same/smilar copy of sheet 1) o
> sheet will be named 2...3..4...and so on!
>
> Please help.
>
> Thanks Sandeep Chhajer.
> Sent on my BlackBerryR from Vodafone
>
> --
> FORUM RULES (986+ 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 (986+ 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
>
--
Sam Mathai Chacko
--
FORUM RULES (986+ 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
Re: $$Excel-Macros$$ want to add our own custom button and Tab in Excel 2007 name in place of add-in
Try this http://www.excelfox.com/forum/f10/how-add-new-ribbon-tab-excel-26/ Regards, Sam Mathai Chacko On Fri, Mar 30, 2012 at 9:37 PM, ashish koul wrote: > check this http://www.rondebruin.nl/ribbon.htm#Examples > > > > > > > On Fri, Mar 30, 2012 at 12:44 PM, Divaker Pandey wrote: > >> Please help, >> >> >> On Thu, Mar 29, 2012 at 4:31 PM, Divaker Pandey wrote: >> >>> thanks for reply noorain >>> >>> But I want as in attached snapshot. Custom Menu >>> >>> hope you will help soon. >>> >>> Divaker >>> >>> >>> >>> >>> >>> >>> On Thu, Mar 29, 2012 at 9:33 AM, Darwin Chan < >>> darwin.chankaw...@gmail.com> wrote: >>> >>>> Hi Noorain, >>>> >>>> Regarding the code provided from above, do the custom control button >>>> and tab include all operations too? >>>> >>>> For example, the sorting button, the operations include in the >>>> following code? I would like to learn more from this. >>>> >>>> .Caption = "Sort Names Descending" >>>> .OnAction = "SortList" >>>> .Parameter = "Dsc" >>>> >>>> >>>> >>>> 2012/3/29 NOORAIN ANSARI >>>> >>>>> See attached add-in's coding for reference >>>>> >>>>> On Wed, Mar 28, 2012 at 9:22 PM, Divaker Pandey >>>>> wrote: >>>>> >>>>>> >>>>>> Hi Expert, >>>>>> >>>>>> I want to add our own custom button and Tab in Excel 2007 name in >>>>>> place add-in. >>>>>> >>>>>> Divaker >>>>>> >>>>>> -- >>>>>> FORUM RULES (986+ 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 >>>>>> >>>>> >>>>> >>>>> >>>>> -- >>>>> Thanks & regards, >>>>> Noorain Ansari >>>>> ** <http://excelmacroworld.blogspot.com/>*http://noorainansari.com/* >>>>> *http://excelmacroworld.blogspot.com/*<http://excelmacroworld.blogspot.com/> >>>>> >>>>> >>>>> -- >>>>> FORUM RULES (986+ 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$$ disable print function in excel 2007
Use this in the workbook module, for the workbook you do not want to print. Private Sub Workbook_BeforePrint(Cancel As Boolean) Cancel = True End Sub Regards, Sam Mathai Chacko On Fri, Mar 30, 2012 at 10:38 PM, Raj Mahapatra wrote: > hi group, > > i wants to disable print function in excel using vba > > appreciate your assistance > > Thanks & Regards > > -- > FORUM RULES (986+ 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 > -- Sam Mathai Chacko -- FORUM RULES (986+ 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
Re: $$Excel-Macros$$ Problem with Format Change Upon Data Validation Change Event
Why not simply use conditional format?
Sam Mathai Chacko
On Thu, Mar 29, 2012 at 8:22 PM, Tiffany wrote:
> Hi -
>
> I'm a little new to VBA but have managed to put together a macro that half
> achieves its intended purpose.
>
> Depending on what is chosen in a data validation cell (any cell in range
> S8 to AL8), the macro is supposed to change the format of 296 cells below
> the data validation cell:
>
>- If "Amount" is chosen in the data validation cell, the format in
>cells below should change to "Comma" style (i.e., 0.00). This works.
>- If "Percent" is chosen in the data validation cell, the format in
>cells below should change to "0.00%". This doesn't work. I'm stumped
>since the language looks right to me and no debugging error pops up. Any
>ideas?
>
> The macro I have now is copied below. Any help you could provide would be
> greatly appreciated.
>
> Private Sub Worksheet_Change(ByVal Target As Excel.Range)
>
> Dim SAType As Range
> Set SAType = Range("S8:AL8")
>
> If Not Application.Intersect(Target, SAType) Is Nothing Then
> On Error Resume Next
> Select Case SAType
> Case "Amount"
> Target.Offset(1, 0).Range("A1:A296").Style = "Comma"
> Case "Percent"
> Target.Offset(1, 0).Range("A1:A296").NumberFormat =
> "0.00%"
> End Select
> End If
> End Sub
>
>
> --
> FORUM RULES (986+ 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
>
--
Sam Mathai Chacko
--
FORUM RULES (986+ 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
Re: $$Excel-Macros$$
The question violates the forum ethics. Read forum rule number 3. Regards, Sam On Thu, Mar 29, 2012 at 9:20 PM, wrote: > Thanks in advance > > > > Hi guys I have one xlsx file and it protected with password now after long > time I try to open that file but can't open it. Caz of password may b I > forget that password or I use wrong password I try my all password but > can't will you please give any solution for that or any excel password > breaker software. > > > Sent from my BlackBerry® Smartphone on Loop Mobile. > > -- > FORUM RULES (986+ 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 > -- Sam Mathai Chacko -- FORUM RULES (986+ 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
Re: $$Excel-Macros$$ Unprotect - VBA Password
Read forum Rule, and abide by it please. Thank you. Regards, Sam On Thu, Mar 29, 2012 at 8:16 PM, amrahs k wrote: > Hi Team, > > I have created a tool in vba with password protected. I have forgot the > password. > > Now I want to do some changes in the tool based on the requirement. so > please remove the vba password and send me the tool as soon as possible. > > Also it would be great if any one help me to create add ins. > > Regards, > Sharma > > -- > FORUM RULES (986+ 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 > -- Sam Mathai Chacko -- FORUM RULES (986+ 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
Re: $$Excel-Macros$$ ****** FIVE YEARS COMPLETION******THANK YOU******
Hey Ayush, excellent achievement. Sorry I am not being able to post frequently. My son's keeping us busy. But my congrats to ALL the great members of this forum, and hope there's more milestones met and achievements garnered in the future also Regards, Sam Mathai Chacko On Thu, Mar 22, 2012 at 10:18 AM, Karan Singh wrote: > Congratulation Ayush...! > > > Kaяan > > <http://www.facebook.com/singhkarann> <http://twitter.com/#%21/karan1237> > <https://plus.google.com/43524614789164919/posts> > <http://www.myspace.com/singhkaran> > <http://www.linkedin.com/in/singhkarann> <http://karanxel.blogspot.com/> > <http://karanxel.wordpress.com/> > > > > > On Thu, Mar 22, 2012 at 4:25 AM, Ayush Jain wrote: > >> Dear members,** >> >> >> >> I am proud to announce that the forum has completed 5 years today. This >> is really great milestone of the forum. >> >> My sincere thanks to each one of you who keep this forum alive by asking >> questions and helping others by providing solutions. >> >> >> >> Over the last five years, I have seen decent growth in the number of >> posts and quality of solutions provided by the experts here. I have learned >> many things from this forum and experts. >> >> In my view, Learning never stops and the discussion forum is the best >> place to learn and share the skills. >> >> >> >> I hardly get time to resolve the excel queries after office hours but I >> try my best to moderate the forum closely. I visit the forum 2-3 times >> daily to approve the messages and to check everything is ok. Please let me >> know the improvements and changes you want to see in the forum. I would be >> happy to hear your feedback. >> >> >> >> Some key achievements of this forum in numbers: >> >> 1) In last 1.5 years, we have seen three people receiving the Microsoft >> MVP award from this forum. This is itself a big achievement for forum and I >> hope to see more deserving people get this award in future. >> >> >> >> 2) This is spam free forum and we hardly get spam messages. In last 5 >> years, 1000 members are banned for sending spam messages >> >> >> >> 3) We are 8400+ members with diversity in expertise, experience and >> location. >> >> >> >> 4) Over 7600+ topics discussed in five years >> >> >> >> Once again many thanks and congratulations to all of you. Keep posting >> and together we will achieve more milestones. >> >> Regards, >> Ayush Jain >> Microsoft MVP >> Forum Owner >> jainayus...@gmail.com >> >> -- >> FORUM RULES (986+ 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 (986+ 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 po
Re: $$Excel-Macros$$ TWO DATA VALIDATION IN ONE CELL
Select the three columns starting from the 8th Row, and Column F, and use this conditional =AND(ISNUMBER(F8),SUM($F8:$H8)<2) Regards Sam Mathai Chacko On Sat, Mar 17, 2012 at 11:52 AM, Pravin Kumar wrote: > Hi folk > > I want to add validation for cell (3 cell) with two condition > > It should not accept any text > > there are 3 field (in each row) and only one should be 1 and rest two > must be 0 > > with custom formula "=SUM($F8:$H8)<2" it follow second rule but no able to > get first rule along with it. > > Please help! > > Thanks > Pravin > > -- > FORUM RULES (986+ 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 > -- Sam Mathai Chacko -- FORUM RULES (986+ 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
Re: $$Excel-Macros$$ Most Helpful Member Feb'12 - Noorain Ansari
Another excellent month of contributions Noorain. Keep up the good work. Regards, Sam Mathai Chacko On Thu, Mar 15, 2012 at 11:53 AM, SAGAR KASANGOTTUWAR < sagarkasangottu...@gmail.com> wrote: > congratulations > > On Thu, Mar 15, 2012 at 11:39 AM, jmothilal wrote: > >> Congratulation Noorain. >> >> >> Mothilal.J >> Universal Computer\ >> Vellore -2 >> >> >> >> >> >> >> On Thu, Mar 15, 2012 at 11:36 AM, Dilip Pandey wrote: >> >>> Congratulations Noorain >>> >>> Keep up the good work and keep helping :) >>> >>> Regards, >>> DILIPandey >>> >>> >>> On Thu, Mar 15, 2012 at 11:31 AM, Abhishek Jain >>> wrote: >>> >>>> Many congratulations Noorain bro! >>>> >>>> Keep up the good work and keep helping us mere mortals in excelling our >>>> lives. :) >>>> >>>> God bless >>>> >>>> >>>> On Thu, Mar 15, 2012 at 11:23 AM, Maries wrote: >>>> >>>>> Congrats Brother.. >>>>> >>>>> >>>>> On Thu, Mar 15, 2012 at 9:50 AM, Sanjib Chatterjee < >>>>> chatterjee.kolk...@gmail.com> wrote: >>>>> >>>>>> Congratulation for you achievement. Hoping for a good luck. >>>>>> >>>>>> sanjib >>>>>> >>>>>> On Thu, Mar 15, 2012 at 4:19 AM, Ayush Jain wrote: >>>>>> >>>>>>> Hello Everyone, >>>>>>> >>>>>>> Noorain Ansari has been selected as 'Most Helpful Member' for the >>>>>>> month of Feb'12 >>>>>>> He has posted 156 posts in Feb'12 and helped many people through his >>>>>>> expertise. He has been consistent contributor to this excel forum but >>>>>>> has >>>>>>> acheived this recognition for third time. >>>>>>> >>>>>>> *About Noorain Ansari :* >>>>>>> [image: noorain.jpg] >>>>>>> >>>>>>> Noorain is a great poet and keep sharing his thoughts on different >>>>>>> topics throgh cool poems. Professionally, he is a Excel aficionado and >>>>>>> presently working as senior business analyst in One97 Communication >>>>>>> Ltd. He >>>>>>> is a MS excel - vba expert and keep sharing his thoughts with this >>>>>>> forum. >>>>>>> You can follow his blogs for Excel knowledge and cool poems : >>>>>>> www.excel-macro.blogspot.com & www.noorain-ansari.blogspot.com >>>>>>> >>>>>>> *Noorain, Many thanks for all your great support to group. Keep it >>>>>>> up* >>>>>>> >>>>>>> *Thanks everyone for helping excel enthusiasts voluntarily !! Keep >>>>>>> it up !! >>>>>>> ** >>>>>>> *Keep posting. >>>>>>> >>>>>>> Regards >>>>>>> Ayush Jain >>>>>>> Group Manager >>>>>>> Microsoft MVP >>>>>>> >>>>>>> -- >>>>>>> FORUM RULES (986+ 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$$ Help Needed
Try this
Sub CreateWordDocs()
Dim xsht As Worksheet
Dim rng As Range
Dim lngLoop As Integer
Set xsht = ActiveWorkbook.Worksheets("Sheet1")
lngLoop = xsht.Cells(Rows.Count, 3).End(xlUp).Row
If lngLoop > 1 Then
With CreateObject("Word.Application")
.Visible = True
For Each rng In xsht.Range("C2:C" & lngLoop)
With .Documents.Add
.SaveAs "F:\Folder\" & rng.Value, 16
.Close 0
End With
Next rng
.Quit 0
End With
End If
End Sub
Regards,
Sam Mathai Chacko
On Wed, Mar 14, 2012 at 9:17 PM, Patil MG wrote:
> Dear Sir
>
> I can able to create Notepad files , but i getting following error when
> trying to create word files
> Run Time Error
> User Defined is not found
>
>
> On Tue, Mar 13, 2012 at 4:39 PM, BNS kumar wrote:
>
>> Hi,
>>
>> check this out
>>
>> Sub CreateWordDocs()
>> ' add a reference to the Word-library
>> ' this is for creating number word Documents and renaming them with
>> file names mentioned in 'C' column
>> ' this code doesn't write any content, it just creates word documents
>> and saves them
>>
>> Dim newapp As Word.Application
>> Dim newDoc As Word.Document
>> Dim xsht As Worksheet
>> Dim filename As Range
>> Dim xcell As Range
>> Dim LastCell As Range
>> Dim i As Integer
>>
>> Set xsht = ActiveWorkbook.Sheets("Sheet1")
>> Set LastCell = xsht.Range("C65000").End(xlUp)
>>
>> If Not LastCell.Row > 1 Then Exit Sub 'condition to check whether
>> filename is entered or not
>>
>> Set filename = xsht.Range("C2:C" & LastCell.Row)
>>
>> Set newapp = CreateObject("word.application")
>> newapp.Visible = True
>>
>> For Each xcell In filename
>>
>> Set newDoc = newapp.Documents.Add
>>
>> With newDoc
>> .SaveAs ("D:\New Folder\" & xcell.Value & ".doc") 'instead of
>> "D;\New Folder", you can give your own path
>> .Close
>> End With
>> Set newDoc = Nothing
>> Next xcell
>>
>> newapp.Quit
>> Set newDoc = Nothing
>> Set newapp = Nothing
>>
>> End Sub
>>
>>
>> --
>>
>> Sub CreateNotePads()
>>
>> 'this with create notepads without writing any content in them
>>
>> Dim fs As Object
>> Dim a As Object
>> Dim xsht As Worksheet
>> Dim filename As Range
>> Dim xcell As Range
>> Dim LastCell As Range
>> Dim i As Integer
>>
>> Set xsht = Sheets("Sheet1")
>> Set LastCell = xsht.Range("C65000").End(xlUp)
>>
>> If Not LastCell.Row > 1 Then Exit Sub 'condition to check whether
>> filename is entered or not
>>
>> Set filename = xsht.Range("C2:C" & LastCell.Row)
>>
>> Set fs = CreateObject("scripting.filesystemobject")
>>
>> For Each xcell In filename
>>
>> Set a = fs.createtextfile("D:\New Folder\" & xcell.Value &
>> ".txt", True) 'give your own path
>>
>> Set a = Nothing
>> Next xcell
>>
>>
>> End Sub
>>
>>
>> Regards
>> Kumar
>>
>>
>> On Tue, Mar 13, 2012 at 2:08 PM, Patil MG wrote:
>>
>>> Hi All
>>>
>>> can any one help me pl..its very urgent,,,
>>>
>>>
>>> On Mon, Mar 12, 2012 at 12:52 PM, Patil MG wrote:
>>>
>>>> Dear Experts,
>>>>
>>>> I have to create 'N' number of empty files of word and note pad files,
>>>> this word will long time to do can any one help to write a macro where in
>>>> which i can create empty word files or note pad files by running the macro,
>>>> my files will be listed in excel file (please refer the attached Excel
>>>> sheets
>>>>
>>>> --
>>>> Thank You
>>>> Patil MG
>>>>
>>>>
>>>> --
>>>> FORUM RULES (986+ members already BANNED for violation)
>>>>
>>>> 1) Use concise, accurate thread titles. Poor thread titles, l
Re: $$Excel-Macros$$ Divide Results from 2 Pivot Tables
There ain't no attachment! Sam On Wed, Mar 14, 2012 at 8:51 AM, Jim wrote: > I'm trying to divide a value in one Pivot Table by a value in a second > Table. Please see the screen shot and the following explanation in > the attached Word document. > > Any ideas? I'm thinking that I may be missing a very obvious alternate > to solving this problem: > > > "The YTD Booking Rate isn’t the solution since the Pivot Tables change > and while the names match up row for row in this example, If Sue > doesn’t book any jobs, her name isn’t in the PT on the right and the > YTD Booking Rate table to the right is incorrect." > > -- > FORUM RULES (986+ 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 > -- Sam Mathai Chacko -- FORUM RULES (986+ 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
Re: $$Excel-Macros$$ Unlist - Table to be constant for every macro to run
*osh.ListObjects(1).UnList*
Regards
Sam Mathai Chacko
On Wed, Mar 7, 2012 at 12:34 AM, dguillett1 wrote:
> try
> Sub removetableSAS()
> dim i as integer
> for i = 1 to 3
>activesheet. osh.listobjects("Table" & i ).unlist
> next i
> End sub
>
> Don Guillett
> Microsoft MVP Excel
> SalesAid Software
> dguille...@gmail.com
>
> *From:* yogananda muthaiah
> *Sent:* Tuesday, March 06, 2012 11:38 AM
> *To:* excel-macros@googlegroups.com
> *Subject:* $$Excel-Macros$$ Unlist - Table to be constant for every macro
> to run
>
> *
>
>1.
>
>Hi,
>
>I am running several times of same macro with listobjects .unlist
>where " Table1" is not constant. it keeps changing when i run the same
>macro again..
>
>Please anyone help me to make table as constant.
>
>("Table1") --- 1st time
>("Table2") --- 2nd time
>("Table3") ---3rd time
>
>
>
>here is the code
>
>
>Sub removetable()
>Dim osh as worksheet
>set osh=activesheet
>osh.listobjects("Table1").unlist
>End sub
>
>
> *
>
>
> Regards
> Yogananda Muthaiah
> Ph : 973 123 7267
>
> --
> FORUM RULES (986+ 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 (986+ 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
>
--
Sam Mathai Chacko
--
FORUM RULES (986+ 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
Re: $$Excel-Macros$$ Exl Adds-in or any software for doing data reconciliations
When you say data reconciliation, do you mean data comparison across sheets? Or is that consolidation? For the former, there's a sheet comparer add-in available on the net, if you search for it. Sam On Wed, Mar 7, 2012 at 5:24 PM, Pranab Brahmangaonkar wrote: > Hi friends, > > Please help me if you are using a any excel adds-in or any software for > data reconciliation. > > Warm regards, > --- > *Pranab A Brahmangaonkar* > Pune, India. > Mobile + 91 9822445858 > > > > -- > FORUM RULES (986+ 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 > -- Sam Mathai Chacko -- FORUM RULES (986+ 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
Re: $$Excel-Macros$$ Error in condition of particular data receive from another sheet
=IFERROR(INDEX(Sheet2!$C$2:$C$15,SMALL(IF(IFERROR(SEARCH(Report!$B$32,Sheet2!$A$2:$A$15,1),0)>0,ROW(Sheet2!$C$2:$C$15)-1,""),ROW()-33)),"") Regards, Sam Mathai Chacko On Wed, Mar 7, 2012 at 9:49 AM, Ashish Bhalara wrote: > > > -- Forwarded message -- > From: Ashish Bhalara > Date: Tue, Mar 6, 2012 at 9:44 AM > Subject: $$Excel-Macros$$ Error in condition of particular data receive > from another sheet > To: excel-macros@googlegroups.com > > > Dear expert, > > There are problem in my condition in attached file of "Condition Problem > sheet". I want same type of condition which written in another attached > sheet of "List Box like Tally". I require the data from another sheet > (Sheet2) of only which match with date, mention in cell B32. Please tell me > what is wrong in my condition. > > Thanks & regards > > Ashish Bhalara > > -- > FORUM RULES (986+ 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 (986+ 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 > -- Sam Mathai Chacko -- FORUM RULES (986+ 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
Re: $$Excel-Macros$$ Search an fill combobox
The ComboBox1_Change event is designed to work that way. Stop using the change event for this. Each time you type a letter, there is an event triggered. If you do not want to search to be triggered, why don't you use a button click for this. Type in the name in the combobox, and then click the button to do the search. Regards, Sam Mathai Chacko On Wed, Mar 7, 2012 at 8:56 PM, Joaowild wrote: > Hi. Someone help with this: I have a book with aprox 20 sheets, many > products are included. Well i need a search a defined product from > combobox inside a userform, but when i write the first letter the > macro run and don't let me write the others. I tried to put a delay > but doesn't work. If you can help me?, Please > > Private Sub ComboBox1_Change() > Dim Producto As String > Dim SheetCount As Integer > Dim counter As Integer > Dim currentSheet As Integer > Producto = ComboBox1.Value > Application.ScreenUpdating = False > On Error Resume Next >currentSheet = ActiveSheet.Index >For counter = 1 To 20 >Sheets(counter).Activate >Cells.Find(What:=Producto, After:=ActiveCell, LookIn:=xlValues, > LookAt _ >:=xlPart, SearchOrder:=xlByRows, SearchDirection:=xlNext, > MatchCase:= _ >False, SearchFormat:=False).Activate >ComboBox1.AddItem ActiveCell.Value >Cells.FindNext(After:=ActiveCell).Activate >ComboBox1.AddItem ActiveCell.Value >If ComoboBox1.Value <> Producto Then >ComboBox1.RemoveItem (ComboBox1.Value <> Producto) >End If > Next counter > > If you need more information please contact contact me > Thanks > > -- > FORUM RULES (986+ 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 > -- Sam Mathai Chacko -- FORUM RULES (986+ 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
Re: $$Excel-Macros$$ : How to use IF Function more than 8 times ?
I'd go with recommended solution of having helper columns. In case you need
a non-helper column solution, use
=LOOKUP(C16,{0,126,131,136,141,146,151,161,171,201},{"125 and Below","126
to 130","131 to 135","136 to 140","141 to 145","146 to 150","151 to
160","160 to 170","171 to 200","200 and above"})
Regards,
Sam Mathai Chacko
On Thu, Mar 8, 2012 at 11:39 AM, xlstime wrote:
> Hi Rushiraj,
>
> you can also you lookup function please find the attachment..
>
>
> On Wed, Mar 7, 2012 at 11:42 AM, Rushiraj Patel <
> rushiraj.pa...@in.aegisglobal.com> wrote:
>
>> Dear Experts,
>>
>> ** **
>>
>> I am using Excel 2003.
>>
>> ** **
>>
>> I have a file in which I need to bifurcate the figures in different
>> slabs. The Count of slabs goes up to 8. As per the Excel 2003 limitations I
>> am only able to get result till 7th slab and not more than that.
>>
>> ** **
>>
>> Please guide if there is any way out. Appended the reference files.
>>
>>
>>
>> ** **
>>
>> ** **
>>
>> Rgds,
>>
>> ** **
>>
>> Rushiraj Patel
>>
>> ** **
>>
>>
>>
>> Save trees. Go Green.
>>
>> --
>> FORUM RULES (986+ 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 (986+ 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
>
--
Sam Mathai Chacko
--
FORUM RULES (986+ 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
<><>
Re: $$Excel-Macros$$ conditinal formatting - based on date col.....(plz help)
A few rows on the top has a logic that is different from the logic in a few rows below. Either that, or I am not able to understand your conditional format rule. Please let us know what is the logic used. Regards, Sam On Thu, Mar 8, 2012 at 11:36 AM, Mohammed Muneer wrote: > ** > Friends plz, formula through conditional formatting can be applicable. > Now I am doing it manually everytime the date change. > > > > Regards, > Muneer, > CC... > > -- > FORUM RULES (986+ 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 > -- Sam Mathai Chacko -- FORUM RULES (986+ 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
Re: $$Excel-Macros$$ copy range
Will be easier if you attach a sample file
Sam
On Tue, Mar 6, 2012 at 5:51 AM, LearnExcel wrote:
> Hi Guys/Girls i use VBA to copy a range using the following code
>
> Selection.AutoFilter Field:=7, Criteria1:="bob"
> ActiveSheet.Range("a1:o1", ActiveSheet.Range("a1").End(xlDown)).Select
>
> the problem that i have is in cell "G" after the last cell there is a
> 3 lines of blank cell and then the report,
>
>
> once the filter is made i want the cell to also include the"Name
> report"
>
>
> can anyone help?
>
> datanamenam nam nam nam nam nam nam
> 3/5/2012random johnbob dog bob johnnew name
> nam
> 3/6/2012random johnbob dog bob johnnew name
> nam
> 3/6/2012random johnbob dog bob johnnew name
> nam
> 3/6/2012bob dog bob johnrandom random johnbob
> 3/6/2012johnbob dog bob johnrandom johnbob
> 3/6/2012random johnbob dog bob johnnew name
> nam
> 3/6/2012bob bob dog bob johnrandom johnbob
> 3/6/2012random johnbob bob random random johnbob
> 3/6/2012random johnbob dog bob johnnew name
> nam
>
>
>
>Name report
>
> --
> FORUM RULES (986+ 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
>
--
Sam Mathai Chacko
--
FORUM RULES (986+ 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
Re: $$Excel-Macros$$ number spliting formula
Why don't you use TODAY() Sam Mathai Chacko On Thu, Mar 1, 2012 at 10:54 PM, danial mansoor wrote: > i used NOW() function to get below date but now i want to split it,i try > to used LEFT and RIGHT function but it does not work on numbers i think > wats the reason? and any suitable formula? > > 3/1/2012 9:54:09 PM > > > -- > Date: Thu, 1 Mar 2012 17:58:56 +0530 > Subject: $$Excel-Macros$$ Userform Filter > From: drdeva...@gmail.com > To: noorain.ans...@gmail.com; grug...@gmail.com > CC: excel-macros@googlegroups.com > > Dear Sir, > >Please help me in creating user for filter. i mean :- for eg. > > 1. customer name:- Ranjan lawran > 2. Mobile:- 6587459874 > 3. state:- delhi. > > > Above data is just an example, in user form, when i click ranjan Lawran, > his particular number *6587459874* as well as his state should come. can > u please do for me that in urgent basis. PLease. > > > > *Regards* > *Deba Ranjan P** > * > *[image: http://www.fileden.com/files/2008/8/21/2058970/greatday.gif]*** > ^^ஜ۩۞۩ஜ▬▬▬ ▬^^ > > * * > * > * > > > -- > FORUM RULES (986+ 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 (986+ 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 > -- Sam Mathai Chacko -- FORUM RULES (986+ 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 <>
Re: $$Excel-Macros$$ "Un-selecting" a cell being copied
Can you post the exact range from where you copy and where to you copy?
On Thu, Mar 1, 2012 at 7:33 PM, Scruffy Huffy wrote:
> Sam,
>
> I'm getting a run-time error '438': Object doesn't support this
> property or method.
>
> Thanks for the advice, though.
>
> Robb
>
> On Mar 1, 8:49 am, Sam Mathai Chacko wrote:
> > Not tested, but try this
> >
> > range("a2:z223").copy
> > with
> >
> range("a1").resize(range("a2:z223").rows.count,range("a2:z223").columns.cou
> nt)
> > .unmerge
> > .paste pastevalues
> > end with
> >
> > Regards,
> > Sam Mathai Chacko
> >
> >
> >
> >
> >
> >
> >
> >
> >
> > On Thu, Mar 1, 2012 at 6:21 PM, Scruffy Huffy
> wrote:
> > > Don,
> >
> > > I did this and got this message: "run-time error '1004': Method
> > > 'Range' of object'_Global' failed"
> >
> > > I'm definitely a novice when it comes to thisanything obvious I'm
> > > missing?
> >
> > > Thanks.
> >
> > > Robb
> >
> > > On Feb 29, 4:55 pm, "dguillett1" wrote:
> > > > range("a2:z223").copy
> > > > range("a1").paste pastevalues
> >
> > > > Don Guillett
> > > > SalesAid Software
> > > > dguille...@gmail.com
> >
> > > > -Original Message-
> > > > From: Scruffy Huffy
> > > > Sent: Wednesday, February 29, 2012 3:51 PM
> > > > To: MS EXCEL AND VBA MACROS
> > > > Subject: Re: $$Excel-Macros$$ "Un-selecting" a cell being copied
> >
> > > > Don,
> >
> > > > Thanks for the suggestion. Any ideas on what to do when the source
> > > > and destination are merged cells of different sizes?
> >
> > > > Right now, I'm copying the source value to a random cell in the
> > > > workbook, and then copying that value to the destination merged
> > > > cells. That just seems clumsy, though.
> >
> > > > Any better ideas?
> >
> > > > Robb
> >
> > > > On Feb 29, 3:00 pm, "dguillett1" wrote:
> > > > > This will copy just the values from the source to the dest. Ranges
> > > MUST be
> > > > > the same size
> >
> > > > > range(destination).value=range(source).value
> > > > > This is much better and the same as
> >
> > > > > range(source).copy
> > > > > range(dest).paste.pastespecial
> >
> > > > > Don Guillett
> > > > > SalesAid Software
> > > > > dguille...@gmail.com
> >
> > > > > -Original Message-
> > > > > From: Scruffy Huffy
> > > > > Sent: Wednesday, February 29, 2012 1:41 PM
> > > > > To: MS EXCEL AND VBA MACROS
> > > > > Subject: Re: $$Excel-Macros$$ "Un-selecting" a cell being copied
> >
> > > > > Sam,
> >
> > > > > I've already tried thatbut it doesn't remove the animation
> around
> > > > > the cell that I copied from. I guess I really need a
> "double-click"
> > > > > option, rather than just a "select" option. I could select fifty
> > > > > different cells in succession, and still not remove the original
> > > > > animated cursors.
> >
> > > > > Also (since you're being so helpful), any ideas on how to paste
> JUST
> > > > > the value of cell? I'm sure there's a "paste special" action that
> I'm
> > > > > missing somewhere, but I'm not having great success. (This is
> > > > > necessary because I need four separate options copied and pasted as
> > > > > static totals: One formula performs the calculations for each
> option,
> > > > > but the total can't be "live linked" to each option).
> >
> > > > > Thanks for your time.
> >
> > > > > Robb
> >
> > > > > On Feb 29, 1:52 pm, Sam Mathai Chacko wrote:
> > > > > > The trick is to select another cell... at any given time, at
> least
> > > one
> > > > > > cell
> > > > > > WILL be selected (if not any other object) in a sheet. So at the
> end
> > > of
> > > > > > your mac
Re: $$Excel-Macros$$ "Un-selecting" a cell being copied
Not tested, but try this
range("a2:z223").copy
with
range("a1").resize(range("a2:z223").rows.count,range("a2:z223").columns.count)
.unmerge
.paste pastevalues
end with
Regards,
Sam Mathai Chacko
On Thu, Mar 1, 2012 at 6:21 PM, Scruffy Huffy wrote:
> Don,
>
> I did this and got this message: "run-time error '1004': Method
> 'Range' of object'_Global' failed"
>
> I'm definitely a novice when it comes to thisanything obvious I'm
> missing?
>
> Thanks.
>
> Robb
>
> On Feb 29, 4:55 pm, "dguillett1" wrote:
> > range("a2:z223").copy
> > range("a1").paste pastevalues
> >
> > Don Guillett
> > SalesAid Software
> > dguille...@gmail.com
> >
> >
> >
> >
> >
> >
> >
> > -Original Message-
> > From: Scruffy Huffy
> > Sent: Wednesday, February 29, 2012 3:51 PM
> > To: MS EXCEL AND VBA MACROS
> > Subject: Re: $$Excel-Macros$$ "Un-selecting" a cell being copied
> >
> > Don,
> >
> > Thanks for the suggestion. Any ideas on what to do when the source
> > and destination are merged cells of different sizes?
> >
> > Right now, I'm copying the source value to a random cell in the
> > workbook, and then copying that value to the destination merged
> > cells. That just seems clumsy, though.
> >
> > Any better ideas?
> >
> > Robb
> >
> > On Feb 29, 3:00 pm, "dguillett1" wrote:
> > > This will copy just the values from the source to the dest. Ranges
> MUST be
> > > the same size
> >
> > > range(destination).value=range(source).value
> > > This is much better and the same as
> >
> > > range(source).copy
> > > range(dest).paste.pastespecial
> >
> > > Don Guillett
> > > SalesAid Software
> > > dguille...@gmail.com
> >
> > > -Original Message-
> > > From: Scruffy Huffy
> > > Sent: Wednesday, February 29, 2012 1:41 PM
> > > To: MS EXCEL AND VBA MACROS
> > > Subject: Re: $$Excel-Macros$$ "Un-selecting" a cell being copied
> >
> > > Sam,
> >
> > > I've already tried thatbut it doesn't remove the animation around
> > > the cell that I copied from. I guess I really need a "double-click"
> > > option, rather than just a "select" option. I could select fifty
> > > different cells in succession, and still not remove the original
> > > animated cursors.
> >
> > > Also (since you're being so helpful), any ideas on how to paste JUST
> > > the value of cell? I'm sure there's a "paste special" action that I'm
> > > missing somewhere, but I'm not having great success. (This is
> > > necessary because I need four separate options copied and pasted as
> > > static totals: One formula performs the calculations for each option,
> > > but the total can't be "live linked" to each option).
> >
> > > Thanks for your time.
> >
> > > Robb
> >
> > > On Feb 29, 1:52 pm, Sam Mathai Chacko wrote:
> > > > The trick is to select another cell... at any given time, at least
> one
> > > > cell
> > > > WILL be selected (if not any other object) in a sheet. So at the end
> of
> > > > your macro, select any other cell, for example the top left cell A1
> >
> > > > Sam Mathai Chacko
> >
> > > > On Thu, Mar 1, 2012 at 12:12 AM, Scruffy Huffy
> > > > wrote:
> > > > > This problem is a bit difficult to describe, but here goes. I'm
> > > > > using a command button macro to select a cell, copy its value, then
> > > > > past the value to another cell.
> >
> > > > > However, I don't know the code to "de-select" the copied cell. In
> > > > > other words, after the copy/paste is complete, the cell that I
> copied
> > > > > from is still highlighted (has the animated "ant trails") going
> around
> > > > > it.
> >
> > > > > I'm sure there's a simple solution. Thanks in advance for your
> help!
> >
> > > > > Robb
> >
> > > > > --
> > > > > FORUM RULES (986+ members already BANNED for violation)
> >
> > > > > 1) Use concise, accurate thread titles. Poor thread titles, like
> > > > > Please
Re: $$Excel-Macros$$ Urgent: Need Help (Assignment)
Apparently, you are right. I thought I saw it in there somewhere. Probably another forum. I guess it should be added. And yeah, I am of the same opinion too. A homework is a homework, and as you said, to learn it, YOU have to DO it. Sam On Thu, Mar 1, 2012 at 2:17 AM, dguillett1 wrote: > Sam, I don’t think the “published” rules prohibit that. I just make it > my policy to encourage posters to learn by doing so I don’t do homework. > YMMV > > Don Guillett > SalesAid Software > dguille...@gmail.com > > *From:* Sam Mathai Chacko > *Sent:* Wednesday, February 29, 2012 2:02 PM > *To:* excel-macros@googlegroups.com > *Subject:* Re: $$Excel-Macros$$ Urgent: Need Help (Assignment) > > Well I thought I'd give it to him for the honesty, but then, can't go > against the rules. Speaking of excel classes, I wish we had that back in > those days. > > Sam > > On Thu, Mar 1, 2012 at 1:10 AM, dguillett1 wrote: > >> Is this “homework” for an excel class? >> >> Don Guillett >> SalesAid Software >> dguille...@gmail.com >> >> *From:* Mani >> *Sent:* Wednesday, February 29, 2012 11:27 AM >> *To:* excel-macros@googlegroups.com >> *Subject:* $$Excel-Macros$$ Urgent: Need Help (Assignment) >> >> Hi Guys, >> >> I am new in excel and have to do this assignment in very less time. Could >> you please suggest an answer to the following problem. Many thanks in >> advance. >> >> (Write a formula to pull out the name of the publisher for country >> with <1st> largets revenue) >> >>Country Publisher Revenue A Alpha 10 A Beta 11 A Gamma 13 A Random 8 B >> Wow 7 B Bla 15 B blu 21 B trash 7 B trush 99 10 >>Country Largest Publisher A 1 >> >> >> >> Regards, >> >> Mani >> -- >> FORUM RULES (986+ 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 (986+ 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 >> > > > > -- > Sam Mathai Chacko > -- > FORUM RULES (986+ 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$$ Urgent: Need Help (Assignment)
Well I thought I'd give it to him for the honesty, but then, can't go against the rules. Speaking of excel classes, I wish we had that back in those days. Sam On Thu, Mar 1, 2012 at 1:10 AM, dguillett1 wrote: > Is this “homework” for an excel class? > > Don Guillett > SalesAid Software > dguille...@gmail.com > > *From:* Mani > *Sent:* Wednesday, February 29, 2012 11:27 AM > *To:* excel-macros@googlegroups.com > *Subject:* $$Excel-Macros$$ Urgent: Need Help (Assignment) > > Hi Guys, > > I am new in excel and have to do this assignment in very less time. Could > you please suggest an answer to the following problem. Many thanks in > advance. > > (Write a formula to pull out the name of the publisher for country > with <1st> largets revenue) > >Country Publisher Revenue A Alpha 10 A Beta 11 A Gamma 13 A Random 8 B > Wow 7 B Bla 15 B blu 21 B trash 7 B trush 99 10 >Country Largest Publisher A 1 > > > > Regards, > > Mani > -- > FORUM RULES (986+ 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 (986+ 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 > -- Sam Mathai Chacko -- FORUM RULES (986+ 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
Re: $$Excel-Macros$$ "Un-selecting" a cell being copied
SH, I'd suggest you try recording macro and after you perform the copy paste special as values, check the macro, you should find how to write the code. Sam On Thu, Mar 1, 2012 at 1:11 AM, Scruffy Huffy wrote: > Sam, > > I've already tried thatbut it doesn't remove the animation around > the cell that I copied from. I guess I really need a "double-click" > option, rather than just a "select" option. I could select fifty > different cells in succession, and still not remove the original > animated cursors. > > Also (since you're being so helpful), any ideas on how to paste JUST > the value of cell? I'm sure there's a "paste special" action that I'm > missing somewhere, but I'm not having great success. (This is > necessary because I need four separate options copied and pasted as > static totals: One formula performs the calculations for each option, > but the total can't be "live linked" to each option). > > Thanks for your time. > > Robb > > > > On Feb 29, 1:52 pm, Sam Mathai Chacko wrote: > > The trick is to select another cell... at any given time, at least one > cell > > WILL be selected (if not any other object) in a sheet. So at the end of > > your macro, select any other cell, for example the top left cell A1 > > > > Sam Mathai Chacko > > > > > > > > > > > > > > > > > > > > On Thu, Mar 1, 2012 at 12:12 AM, Scruffy Huffy > wrote: > > > This problem is a bit difficult to describe, but here goes. I'm > > > using a command button macro to select a cell, copy its value, then > > > past the value to another cell. > > > > > However, I don't know the code to "de-select" the copied cell. In > > > other words, after the copy/paste is complete, the cell that I copied > > > from is still highlighted (has the animated "ant trails") going around > > > it. > > > > > I'm sure there's a simple solution. Thanks in advance for your help! > > > > > Robb > > > > > -- > > > FORUM RULES (986+ 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 > > > > -- > > Sam Mathai Chacko > > -- > FORUM RULES (986+ 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 > -- Sam Mathai Chacko -- FORUM RULES (986+ 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
Re: $$Excel-Macros$$ "Un-selecting" a cell being copied
The trick is to select another cell... at any given time, at least one cell WILL be selected (if not any other object) in a sheet. So at the end of your macro, select any other cell, for example the top left cell A1 Sam Mathai Chacko On Thu, Mar 1, 2012 at 12:12 AM, Scruffy Huffy wrote: > This problem is a bit difficult to describe, but here goes. I'm > using a command button macro to select a cell, copy its value, then > past the value to another cell. > > However, I don't know the code to "de-select" the copied cell. In > other words, after the copy/paste is complete, the cell that I copied > from is still highlighted (has the animated "ant trails") going around > it. > > I'm sure there's a simple solution. Thanks in advance for your help! > > Robb > > -- > FORUM RULES (986+ 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 > -- Sam Mathai Chacko -- FORUM RULES (986+ 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
Re: $$Excel-Macros$$ Help on gathering duplicate summing and counting
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 (986+ 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 (986+ 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 (986+ 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 (986+ 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 > -- Sam Mathai Chacko -- FORUM RULES (986+ 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
Re: $$Excel-Macros$$ date format
No it isn't, it's just that it's a safe practice Maries On Mon, Feb 27, 2012 at 8:29 PM, Maries wrote: > Hi Sam, > > Is "*Double Minus" *required? > > > On Mon, Feb 27, 2012 at 5:47 PM, Sam Mathai Chacko wrote: > >> Hi Lee, >> >> =WEEKNUM(--TEXT(A1,"\/00\/00")) >> >> >> http://www.excelfox.com/forum/f13/convert-text-mmdd-format-date-format-74/ >> >> In your case, I'd use >> >> * >> =TEXT(--TEXT(A1,"\/00\/00"),"mmm")&"-W"&WEEKNUM(--TEXT(A1,"\/00\/00")) >> * to give *Oct-W41* >> >> Regards, >> >> Sam Mathai Chacko >> >> >> On Mon, Feb 27, 2012 at 11:47 AM, NOORAIN ANSARI < >> noorain.ans...@gmail.com> wrote: >> >>> Hi Sara, >>> >>> Addition in Venkat Formula : >>> >>> For weeknum >>> =WEEKNUM(DATE(LEFT(A1,4),MID(A1,5,2),RIGHT(A1,2))) >>> For Month >>> =MONTH(DATE(LEFT(A1,4),MID(A1,5,2),RIGHT(A1,2))) >>> On Mon, Feb 27, 2012 at 7:52 AM, Venkat CV wrote: >>> >>>> Hi , >>>> >>>> Try This, >>>> >>>> >>>> *=DATE(LEFT(A1,4),MID(A1,5,2),RIGHT(A1,2))* >>>> >>>> *Best Regards,* >>>> *Venkat * >>>> *Chennai* >>>> *My Linked in profile<http://in.linkedin.com/pub/venkatesan-c/21/492/a71> >>>> * >>>> >>>> >>>> On Mon, Feb 27, 2012 at 1:45 AM, Sara Lee wrote: >>>> >>>>> i have date in this format-- 20011012... yrmmdd.. i want to extract >>>>> week no and month from this date. what is the formula >>>>> >>>>> -- >>>>> FORUM RULES (986+ 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 (986+ 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 >>>> >>> >>> >>> >>> -- >>> Thanks & regards, >>> Noorain Ansari >>> ** <http://excelmacroworld.blogspot.com/>*http://noorainansari.com/* >>> *http://excelmacroworld.blogspot.com/*<http://excelmacrow
Re: $$Excel-Macros$$ $$Excel-Macros$$ Validate text and number in PAN
Ah! Quote Haseeb {I think this part ISNUMBER(--MID(A3,6,4)) will allow
entry with 3 spaces before the fourth digit :-) , like}
I think that's a very good catch Haseeb. :)
I think adding an IFERROR(FIND(" ",Range)) will solve the problem.....
Regards,
Sam Mathai Chacko
On Mon, Feb 27, 2012 at 12:50 PM, Vijayendra Rao
wrote:
> Thanks Sam, Maries & Haseeb.
>
> All three solutions are working fine.thanks again.
>
> Regards,
> Vijayendra
>
> 2012/2/27 Haseeb Avarakkan
>
>> Hi Sam,
>>
>> I think this part ISNUMBER(--MID(A3,6,4)) will allow entry with 3 spaces
>> before the fourth digit :-) , like
>>
>> ABCDE 1D
>>
>> Hi Vijayendra,
>>
>> This is my try. Firstly define 3 names to avoid INDIRECT function.
>>
>> Name: *Alpha*
>> On refers to:
>> ={"A";"B";"C";"D";"E";"F";"G";"H";"I";"J";"K";"L";"M";"N";"O";"P";"Q";"R";"S";"T";"U";"V";"W";"X";"Y";"Z"}
>>
>> Name: *Row*
>> Refers to: ={1;2;3;4;5}
>>
>> Name: *Col*
>> Refers to: ={6,7,8,9}
>>
>> Then use this formula in Data Validation >> Custom. Make sure you have
>> unselect *Ignore blank*
>>
>>
>> =SUMPRODUCT(ISNUMBER(MATCH(MID(C2,Row,1),Alpha,0))*ISNUMBER(MID(C2,Col,1)+0)*ISNUMBER(MATCH(MID(C2,10,250),Alpha,0)))=20
>>
>> HTH
>> Haseeb
>>
>> --
>> FORUM RULES (986+ 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
>>
>
>
>
> --
> ಧನ್ಯವಾದಗಳು,
> ವಿಜಯೇಂದ್ರ,
> ೯೪೪೯೧ ೬೭೬೩೧
>
> Regards,
> Vijayendra
> 94491 67631
>
> --
> FORUM RULES (986+ 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
>
--
Sam Mathai Chacko
--
FORUM RULES (986+ 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
Re: $$Excel-Macros$$ date format
Hi Lee, =WEEKNUM(--TEXT(A1,"\/00\/00")) http://www.excelfox.com/forum/f13/convert-text-mmdd-format-date-format-74/ In your case, I'd use * =TEXT(--TEXT(A1,"\/00\/00"),"mmm")&"-W"&WEEKNUM(--TEXT(A1,"\/00\/00")) * to give *Oct-W41* Regards, Sam Mathai Chacko On Mon, Feb 27, 2012 at 11:47 AM, NOORAIN ANSARI wrote: > Hi Sara, > > Addition in Venkat Formula : > > For weeknum > =WEEKNUM(DATE(LEFT(A1,4),MID(A1,5,2),RIGHT(A1,2))) > For Month > =MONTH(DATE(LEFT(A1,4),MID(A1,5,2),RIGHT(A1,2))) > On Mon, Feb 27, 2012 at 7:52 AM, Venkat CV wrote: > >> Hi , >> >> Try This, >> >> >> *=DATE(LEFT(A1,4),MID(A1,5,2),RIGHT(A1,2))* >> >> *Best Regards,* >> *Venkat * >> *Chennai* >> *My Linked in profile<http://in.linkedin.com/pub/venkatesan-c/21/492/a71> >> * >> >> >> On Mon, Feb 27, 2012 at 1:45 AM, Sara Lee wrote: >> >>> i have date in this format-- 20011012... yrmmdd.. i want to extract >>> week no and month from this date. what is the formula >>> >>> -- >>> FORUM RULES (986+ 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 (986+ 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 >> > > > > -- > Thanks & regards, > Noorain Ansari > ** <http://excelmacroworld.blogspot.com/>*http://noorainansari.com/* > *http://excelmacroworld.blogspot.com/*<http://excelmacroworld.blogspot.com/> > > > -- > FORUM RULES (986+ 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 > -- Sam Mathai Chacko -- FORUM RULES (986+ 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
Re: $$Excel-Macros$$ List Box Like Tally Software
For the position, use Private Sub UserForm_Activate() Me.Top = 150 Me.Left = 250 End Sub adjust it based on your requirement... to make it dynamic for any excel application or screen size, you'll have to use API For ISERROR problem in Excel 2003, use =IF(ISERR(INDEX(Data!$A$3:$A$640,SMALL(IF(IFERROR(SEARCH($E$1,Data!$E$3:$E$640,1),0)>0,ROW(Data!$E$3:$E$640)-2,""),ROW()-4))),"",INDEX(Data!$A$3:$A$640,SMALL(IF(IFERROR(SEARCH($E$1,Data!$E$3:$E$640,1),0)>0,ROW(Data!$E$3:$E$640)-2,""),ROW()-4))) in A5 and drag formula across Regards, Sam Mathai Chacko On Mon, Feb 27, 2012 at 10:57 AM, chandra sekaran wrote: > Dear all > > > this file not working with excel2003 iserror function > > regards > chandru > > On Mon, Feb 20, 2012 at 8:28 PM, Maries wrote: > >> Hi, >> >> I got your logic. Check the attachment. >> >> Type your text in cell D1 & Enter. It will give answer. >> >> Regards, >> >> MARIES. >> >> >> On Mon, Feb 20, 2012 at 4:39 PM, chandra sekaran >> wrote: >> >>> Hi maries, >>> >>> thanks for your Reply, >>> >>> MyOutput Sheet D1 Activate then My List of Cutomer may >>> shwon seperate list box or Below D1 Cell there itself we want to select >>> or like sheet Name Tally List box like that if possible [ First time i >>> do not know what are the customer are there in my Data so once D1 is >>> Activate Unique My Cutomer will display if possible please >>> >>> Regards >>> chandru >>> >>> >>> >>> >>> >>> On Mon, Feb 20, 2012 at 5:54 PM, Maries wrote: >>> >>>> Hi, >>>> >>>> Find the attached file. If you type first name in search cell, >>>> respective datas will show below. >>>> >>>> Regards, >>>> >>>> MARIES. >>>> >>>> >>>> On Mon, Feb 20, 2012 at 2:03 PM, chandra sekaran < >>>> duraichan...@gmail.com> wrote: >>>> >>>>> Dear all >>>>> Here with attached List Box like Tally is this possible with >>>>> excelonce Active List box or Cell shown under all name after >>>>> enter first letter than showing start with all names like that >>>>> Advance Thanks for all >>>>> >>>>> Regards >>>>> chandru >>>>> >>>>> >>>>> >>>>> >>>>> -- >>>>> FORUM RULES (986+ 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 (986+ 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. >>>&g
Re: $$Excel-Macros$$ help needed??
Instead of using the CONCATENATE function with multiple if conditions,
better to use a simple helper column with a small formula like this
J2=IF(C2="Y",IF(I2<>"",I2&",","")&C$1,TEXT(I2,""))
And H2=LOOKUP("ZZ",J2:N2)
Regards,
Sam Mathai Chacko
On Sun, Feb 26, 2012 at 9:33 PM, xlstime wrote:
> please find the attachment
>
> On Sun, Feb 26, 2012 at 9:19 PM, Sourabh Salgotra wrote:
>
>> Dear sir,
>>plz download the attachment and help me...
>>
>> --
>> FORUM RULES (986+ 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 (986+ 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
>
--
Sam Mathai Chacko
--
FORUM RULES (986+ 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
HELP NEEDED ON SUBJECTS.xls
Description: MS-Excel spreadsheet
Re: $$Excel-Macros$$ Extract last digit number
=SUBSTITUTE(REPLACE(A1,1,FIND("(",A1),""),")","")
Regards,
Sam Mathai Chacko
On Sat, Feb 25, 2012 at 9:49 PM, Lokesh Loki wrote:
> Hi All,
>
> I need a formula to extract 20 only form the below text and fix the same
> in to next cell.
>
>
> Canada_20120223_E002_E001(20)
>
> regards
> Lokesh.M
>
> --
> FORUM RULES (986+ 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
>
--
Sam Mathai Chacko
--
FORUM RULES (986+ 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
Re: $$Excel-Macros$$ how to find a text in a folder
t;>>>>> . >>>>>>> >>>>>>> >>>>>>> -- >>>>>>> FORUM RULES (986+ 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 (986+ 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 (986+ 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 (986+ 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 (986+ 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 (986+ 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 > -- Sam Mathai Chacko -- FORUM RULES (986+ 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
Re: $$Excel-Macros$$ how to find a text in a folder
urity >>>>>> 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 (986+ 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 (986+ 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 (986+ 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 (986+ 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 > -- Sam Mathai Chacko -- FORUM RULES (986+ 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
Re: $$Excel-Macros$$ $$Excel-Macros$$ Validate text and number in PAN
I believe the OP was asking for a data validation Regards, Sam Mathai Chacko On Sat, Feb 25, 2012 at 8:54 PM, Maries wrote: > Hi, > > Please find the attachment. > > Regards, > > MARIES. > > > On Sat, Feb 25, 2012 at 5:59 PM, Vijayendra Rao > wrote: > >> Dear All, >> >> I want to validate text and numbers in PAN number. Validation required >> as per below conditions. >> >> >> · Length should be 10 >> >> · First 5 character should be text >> >> · Next 4 should be number >> >> · Last character should be text >> >> >> Attached excvel file for your reference. >> >> >> >> Can you please help on the same. >> >> Regards, >> Vijayendra >> 94491 67631 >> >> -- >> FORUM RULES (986+ 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 (986+ 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 > -- Sam Mathai Chacko -- FORUM RULES (986+ 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 Validate text and number in PAN.xlsx Description: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet
Re: $$Excel-Macros$$ Toolbar
Yes this can be done
Just a quick scrap here with bare minimum requirements...
Sub AddMacroToToolBar()
Dim lngLoop As Long
Const strMacroNames = "Macro,Delete"
For lngLoop = 1 To 2
With Application.CommandBars("Worksheet Menu
Bar").Controls("&Tools")
On Error Resume Next
.Controls("Run " & Split(strMacroNames, ",")(lngLoop -
1)).Delete
Err.Clear: On Error GoTo 0
With .Controls.Add(Type:=msoControlButton, ID:=1)
.Style = msoButtonIconAndCaption
.Caption = "Run " & Split(strMacroNames, ",")(lngLoop - 1)
.OnAction = Split(strMacroNames, ",")(lngLoop - 1)
End With
End With
Next
End Sub
Regards,
Sam Mathai Chacko
On Sat, Feb 25, 2012 at 6:44 AM, Cab Boose wrote:
> Hi
>
> Xl2000
>
> I want to add some macros to the existing'Tools' toolbar. Have
> looked at several on the net. JKP, Contextures, Vbax, etc. They seem to
> use mainly a floating toolbar.
>
> I just want to run a macro that says - Add this macro (from a list
> showing in current workbook) onto the 'Tools' toolbar, and maybe a 'Delete'
> from tools toolbar.
>
> Anyone know of a suitable code online.
>
>
> Thanks and regards
>
> Charlie Harris
>
>
>
>
>
> --
> FORUM RULES (986+ 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
>
--
Sam Mathai Chacko
--
FORUM RULES (986+ 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
Re: $$Excel-Macros$$ Formula for bucket
If you have a pretty long range, you could use another range to do the
lookup. I have also added the below suggestion to the attachment.
Regards,
Sam Mathai Chacko
On Sat, Feb 25, 2012 at 10:15 AM, Maries wrote:
> Hi,
>
> Try it..
>
> *=VLOOKUP(A1,{0,"0-2";3,"2-4";5,"4-6";7,"6+"},2,TRUE)*
> **
> *=LOOKUP(A1,{0;3;5;7},{"0-2";"2-4";"4-6";"6+"})*
>
> Regards,
>
> MARIES.
> On Fri, Feb 24, 2012 at 11:31 PM, xlstime wrote:
>
>> Hi Pankaj,
>>
>> You can use Lookup function.
>>
>> please find the example sheet.
>>
>>
>> On Sat, Feb 25, 2012 at 12:57 AM, Secret Shot wrote:
>>
>>> Dear group,
>>>
>>> I want to make bucket of age like 0-2,2-4,4-6 etc.
>>> However I can do this by if formula.
>>> But that is very lanthy formula and also excel 2003 dose not support
>>> nested if greater then 7.
>>> So can anyone pls help me with any shortest way to do it pls.
>>>
>>> Regards
>>> Pankaj k pandey
>>>
>>> --
>>> FORUM RULES (986+ 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 (986+ 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 (986+ 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
>
--
Sam Mathai Chacko
--
FORUM RULES (986+ 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
Age Group Using Vlookup.xlsx
Description: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet
Re: $$Excel-Macros$$ Removing zero value from pivot
Ashish, please check my attachment before commenting Sam On Sat, Feb 25, 2012 at 3:09 PM, Ashish Bhalara wrote: > Dear Sam, > > Thanks for reply but filter is not enable on value in pivot, is there any > other way ? > > Ashish > > > On Sat, Feb 25, 2012 at 3:04 PM, Sam Mathai Chacko wrote: > >> Add an extra column in the pivot and use as filter.... >> >> Regards, >> >> Sam Mathai Chacko >> >> >> On Sat, Feb 25, 2012 at 2:17 PM, Ashish Bhalara < >> ashishbhalar...@gmail.com> wrote: >> >>> Dear expert, >>> >>> Is there possible to remove zero value raw from pivot? Please find the >>> attachment data of pivot file. >>> >>> Thanks & regards >>> >>> Ashish Bhalara >>> >>> -- >>> FORUM RULES (986+ 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 >>> >> >> >> >> -- >> Sam Mathai Chacko >> >> -- >> FORUM RULES (986+ 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 (986+ 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 > -- Sam Mathai Chacko -- FORUM RULES (986+ 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
Re: $$Excel-Macros$$ Removing zero value from pivot
Add an extra column in the pivot and use as filter Regards, Sam Mathai Chacko On Sat, Feb 25, 2012 at 2:17 PM, Ashish Bhalara wrote: > Dear expert, > > Is there possible to remove zero value raw from pivot? Please find the > attachment data of pivot file. > > Thanks & regards > > Ashish Bhalara > > -- > FORUM RULES (986+ 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 > -- Sam Mathai Chacko -- FORUM RULES (986+ 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 PIVOT.xlsx Description: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet
Re: $$Excel-Macros$$ Time capture (NOW)
Change sheet calculation to manual! Sam Mathai Chacko On Fri, Feb 24, 2012 at 11:45 PM, wrote: > Dear Excel Gurus, > > I need help with a formula.. All I need is to do I capture current time, > and freeze the same... For eg: if I need to enter the time as 10.01 am > using 'NOW' Excel should capture the time as 10.01 and not refresh it, > as soon as the system time changes... > > I know there are alternate options like shift + ; but I need the formula > for the same using 'now'... Kindly help if possible.. > > Thank for your continuous support! > > > Krishnan > Sent on my BlackBerry® from Vodafone > > -- > FORUM RULES (986+ 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 > -- Sam Mathai Chacko -- FORUM RULES (986+ 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
Re: $$Excel-Macros$$ Excel Help needed - To convert date format in to Decimal Min
If you insist on using your original formula, try a more lengthier *=QUOTIENT(G91,1)*1440+HOUR(**G9**1)*60+MINUTE(**G9**1)+SECOND(**G9**1)/60* But *=G91*1440 will give the same answer* Regards, Sam Mathai Chacko On Fri, Feb 24, 2012 at 10:19 PM, Sam Mathai Chacko wrote: > *=G91*1440* > > Regards, > > Sam Mathai Chacko > > > > > On Fri, Feb 24, 2012 at 4:53 PM, satish > wrote: > >> Hi all, >> >> I have the data in below format, I try to convert the date format in >> to decimal Minutes. It comes well when the data below 24 Hrs, as soon >> as it exceed 24 Hrs, it gives a wrong fig. >> >> I used the below formula to get answers >> >> =HOUR(G91)*60+MINUTE(G91)+SECOND(G91)/60 >> >> gprs - national - 26:48:21168.3500 - Wrong >> gprs - national 25:15:4718. - Wrong >> gprs - national 21:23:051283.0833 - Correct >> to other uk mobile operators19:50:071190.1167 - Correct >> to other uk mobile operators14:35:19875.3167 - Correct >> gprs - national 11:28:10688.1667 - Correct >> >> >> Thanks for help >> >> Rgds >> >> Kumar >> >> -- >> FORUM RULES (986+ 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 >> > > > > -- > Sam Mathai Chacko > -- Sam Mathai Chacko -- FORUM RULES (986+ 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
Re: $$Excel-Macros$$ Excel Help needed - To convert date format in to Decimal Min
*=G91*1440* Regards, Sam Mathai Chacko On Fri, Feb 24, 2012 at 4:53 PM, satish wrote: > Hi all, > > I have the data in below format, I try to convert the date format in > to decimal Minutes. It comes well when the data below 24 Hrs, as soon > as it exceed 24 Hrs, it gives a wrong fig. > > I used the below formula to get answers > > =HOUR(G91)*60+MINUTE(G91)+SECOND(G91)/60 > > gprs - national - 26:48:21168.3500 - Wrong > gprs - national 25:15:4718. - Wrong > gprs - national 21:23:051283.0833 - Correct > to other uk mobile operators19:50:071190.1167 - Correct > to other uk mobile operators14:35:19875.3167 - Correct > gprs - national 11:28:10688.1667 - Correct > > > Thanks for help > > Rgds > > Kumar > > -- > FORUM RULES (986+ 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 > -- Sam Mathai Chacko -- FORUM RULES (986+ 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
Re: $$Excel-Macros$$ Meaning of minus minus or -- in an Excel function
I know I mentioned otherwise in http://osdir.com/ml/excel-macros/2011-12/msg00084.html However,* you cannot use ++* You can use +0, *1, -0, /1, ^1 etc, but -- is the most elegant and common approach. Regards, Sam Mathai Chacko On Thu, Feb 23, 2012 at 12:21 PM, Asa Rossoff wrote: > Hi Johann, > > To add to Noorain's explanation: > > ** ** > > Boolean (True/False) values cannot be added, multiplied, averaged, etc. by > aggregate functions such as SUM(), PRODUCT(), AVERAGE(), MEDIAN(), and > SUMPRODUCT. In fact, boolean values are always completely ignored by > aggregate functions. > > ** ** > > To summarize boolean values with an aggregate function, you must convert > the the boolean to a number. When you use a value in a formula as if it > were a different type of data, Excel will in most circumstances convert the > value to that type of data. This implicit method of data type conversion > is called coercion. You can coerce boolean values to a number, text > representations of a number to a number, textual dates/times to actual > date/times (dateserials), anything to text,… > > ** ** > > Boolean values can be coerced to a number (1 for True, 0 for False) in > several ways. If you use an arithmetic operator with a boolean value, the > boolean is coerced to become a number. In recent versions of Excel, the > N() function performs an explicit conversion to a number and works in many > circumstances (although arithmetic coercion works more broadly). For > completeness there is also the similar VALUE function which can convert > most data types to numbers, but not booleans. > > ** ** > > When you don't need to use an arithmetic operator in your formula already, > but you need to coerce a boolean value, you have to device a neutral > expression that includes an arithmetic operator, like --boolean, boolean*1, > boolean+0, boolean/1. -- is often favored. Your formula is still clean, > the -- form would probably not be used in other circumstances, and it's a > fast calculation for Excel. > > ** ** > > Usually the requirement to utilize boolean values as numbers comes up in > array formulas and SUMPRODUCT formulas (similar because SUMPRODUCT resolves > array formulas too). Numeric representations of boolean values is useful > in these formulas because when multiplied by another value, that value can > either be included in a summary when the boolean is True/1, or not, when > False/0. That boolean value or expression has become a criteria for what > to summarize. > > ** ** > > Asa > > ** ** > > *From:* excel-macros@googlegroups.com [mailto: > excel-macros@googlegroups.com] *On Behalf Of *NOORAIN ANSARI > *Sent:* Wednesday, February 22, 2012 7:06 PM > *To:* excel-macros@googlegroups.com > *Subject:* Re: $$Excel-Macros$$ Meaning of minus minus or -- in an Excel > function > > ** ** > > Dear johann, > > > > The -- is used as an unary operator to convert a boolean value ie, > TRUE/FALSE in to 1/0. Sumproduct for example does not evaluate non-numeric > values that results in a formula like the boolean results in the array > equation A1:A10="johann". > > So to negate this, we use unary operator -- with TRUE or FALSE to give 1 > or 0 > > We can also use ++ ,+0,*1 > > In fact you can also use a multiplier or a divisor of 1 > > In case you'd like more information, look up in google. Here's something > from an Excel MVP > > http://www.mcgimpsey.com/excel/formulae/doubleneg.html > > On Thu, Feb 23, 2012 at 5:24 AM, johann wrote: > > Hi Cyberspace, > > I'd like to understand the meaning of "--" in front of an Excel > function like : > =--sumproduct(...) > =--substitute(...) > ... and other I can't recall > > I know that in some programming language it's a way to "decrement" a > variable like i = i - 1 can be i-- or --i following the precedence of > the operator --. > > Thanks, > Cyberuser > > -- > FORUM RULES (986+ 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
