$$Excel-Macros$$ Exit Sub if no match
If there is no match, I'd like to enter my own value. Just can not
figure out how to write code! As the code stands now it will not allow
me to enter my own value, returns the #N/A error and each time I try
and change this it fires the code again and return the error again. I
need something like... If A3 = #N/A then Exit Sub Else run code?
Thanks in advance!!!
'Worksheets(Worksheet2).Range(B3).Formula =
=if(A3=,,index('Customer Record'!B:B,match(A3,'Customer
Record'!A:A,0),1))
'Worksheets(Worksheet2).Range(B3,
Range(A65536).End(xlUp).Offset(1, 1)).FillDown
--
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links :
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
To post to this group, send email to excel-macros@googlegroups.com
Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel
$$Excel-Macros$$ Urgent:: Is there a way out to increase the cell limit to beyond 255.
Hi All, I am currently working on an excel (2003)sheet whose cell character length is beyond 255. I am able to copy just 255 characters. The remaining characters get truncated.Your help in this regard will be very much appreciated. Example cell character length =300. While pasting or doing any cell operations, I see only the first 255 characters considered. Rgds, Bharghav R -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel
Re: $$Excel-Macros$$ Automation of formula
Hi, What's the code you want to pass and to which cell. mention that also Regards Umesh Dev On Mon, May 23, 2011 at 11:32 PM, Skanda skanda.pokkun...@gmail.com wrote: The column difference highlighted in green is calculated as the difference between the two cells to its left.Then %difference is the percentage in their difference and abs difference is their absolute difference. How to code such that if i pass the formula these three fields are calculated for rest of the columns. attached is the worksheet. -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel
RE: $$Excel-Macros$$ Recovering corrupted excel file
Send your File.. From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of Chandra Shekar Sent: Monday, May 23, 2011 11:33 AM To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ Recovering corrupted excel file Hi, This I tried but still I could not able to recover the file. Let me know is there any other way to recover file. Thanks, Chandra Shekar B On Sat, May 21, 2011 at 10:11 AM, ashish koul koul.ash...@gmail.com wrote: http://office.microsoft.com/en-us/excel-help/repairing-corrupted-files-in-ex cel-HA001034656.aspx On Fri, May 20, 2011 at 5:13 PM, Chandra Shekar chandrashekarb@gmail.com wrote: Hi can u expalin briefly in steps. Thanks, Chandra Shekar B On Fri, May 20, 2011 at 5:02 PM, rajan verma rajanverma1...@gmail.com wrote: Use a Function Like this ='C:\Users\Xl_Lover\Desktop\[Book2[Sheet1]]Index'!A1 On Fri, May 20, 2011 at 4:00 PM, Chandra Shekar chandrashekarb@gmail.com wrote: Hi, Is there any way to recover corrupted excel file. Thanks, Chandra Shekar B -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com http://www.excel-macros.blogspot.com/ 4. Learn VBA Macros at http://www.quickvba.blogspot.com http://www.quickvba.blogspot.com/ 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com http://exceldailytip.blogspot.com/ To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel -- Regards Rajan verma +91 9158998701 -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com http://www.excel-macros.blogspot.com/ 4. Learn VBA Macros at http://www.quickvba.blogspot.com http://www.quickvba.blogspot.com/ 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com http://exceldailytip.blogspot.com/ To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com http://www.excel-macros.blogspot.com/ 4. Learn VBA Macros at http://www.quickvba.blogspot.com http://www.quickvba.blogspot.com/ 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com http://exceldailytip.blogspot.com/ To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel -- Regards Ashish Koul http://akoul.blogspot.com/ akoul.blogspot.com http://akoul.wordpress.com/ akoul.wordpress.com My http://in.linkedin.com/pub/ashish-koul/10/400/830 Linkedin Profile P Before printing, think about the environment. -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com http://www.excel-macros.blogspot.com/ 4. Learn VBA Macros at http://www.quickvba.blogspot.com http://www.quickvba.blogspot.com/ 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com http://exceldailytip.blogspot.com/ To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel --
Re: $$Excel-Macros$$ Need a formula for getting the output of one calculation as RATIO
Dear Rajan, I would be thank ful for your help. But I m not getting how exactly to run this VBA code in my required Excell Work Book. Can u help me...? Regards, Saroj On Mon, May 23, 2011 at 8:20 PM, rajan verma rajanverma1...@gmail.comwrote: Amended.. Function Ratio2(*ParamArray* arr()) As String For i = 0 To UBound(arr) Ratio2 = Ratio2 arr(i) / WorksheetFunction.Gcd(arr) : Next Ratio2 = Left(Ratio2, Len(Ratio2) - 1) End Function On Mon, May 23, 2011 at 8:16 PM, rajan verma rajanverma1...@gmail.comwrote: *Try this Function* Function Ratio2(*ParamArray* arr()) As String Dim Arr2(1) As Integer For i = 0 To UBound(arr) Ratio2 = Ratio2 arr(i) / WorksheetFunction.Gcd(arr) : Next Ratio2 = Left(Ratio2, Len(Ratio2) - 1) End Function On Mon, May 23, 2011 at 12:35 PM, Kabir:-) saroj.32...@gmail.comwrote: Dear Rajan, Thanks for your formulait works. But I want to know, will there be any macro or VBA code for the query like this. Kindly help me if anything available like such. Thank you all... Regards, Saroj. On Sat, May 21, 2011 at 10:00 AM, Rajan_Verma rajanverma1...@gmail.comwrote: Hi Kabir, See if it help. *From:* excel-macros@googlegroups.com [mailto: excel-macros@googlegroups.com] *On Behalf Of *Kabir:-) *Sent:* Friday, May 20, 2011 5:09 PM *To:* excel-macros@googlegroups.com *Subject:* $$Excel-Macros$$ Need a formula for getting the output of one calculation as RATIO Dear Gurus, I need a formula for calculated two numbers and resulted output should be in a Ratio.i.e., 2:1 or 1.5:3. Thank you in advance, Regards, Saroj. -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel -- Regards Rajan verma +91 9158998701 -- Regards Rajan verma +91 9158998701 -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel
Re: $$Excel-Macros$$ Recovering corrupted excel file
Dear experts Can you tell me what is use of snerios in excel. Regards Manoj On 5/24/11, Rajan_Verma rajanverma1...@gmail.com wrote: Send your File.. From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of Chandra Shekar Sent: Monday, May 23, 2011 11:33 AM To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ Recovering corrupted excel file Hi, This I tried but still I could not able to recover the file. Let me know is there any other way to recover file. Thanks, Chandra Shekar B On Sat, May 21, 2011 at 10:11 AM, ashish koul koul.ash...@gmail.com wrote: http://office.microsoft.com/en-us/excel-help/repairing-corrupted-files-in-ex cel-HA001034656.aspx On Fri, May 20, 2011 at 5:13 PM, Chandra Shekar chandrashekarb@gmail.com wrote: Hi can u expalin briefly in steps. Thanks, Chandra Shekar B On Fri, May 20, 2011 at 5:02 PM, rajan verma rajanverma1...@gmail.com wrote: Use a Function Like this ='C:\Users\Xl_Lover\Desktop\[Book2[Sheet1]]Index'!A1 On Fri, May 20, 2011 at 4:00 PM, Chandra Shekar chandrashekarb@gmail.com wrote: Hi, Is there any way to recover corrupted excel file. Thanks, Chandra Shekar B -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com http://www.excel-macros.blogspot.com/ 4. Learn VBA Macros at http://www.quickvba.blogspot.com http://www.quickvba.blogspot.com/ 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com http://exceldailytip.blogspot.com/ To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel -- Regards Rajan verma +91 9158998701 -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com http://www.excel-macros.blogspot.com/ 4. Learn VBA Macros at http://www.quickvba.blogspot.com http://www.quickvba.blogspot.com/ 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com http://exceldailytip.blogspot.com/ To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com http://www.excel-macros.blogspot.com/ 4. Learn VBA Macros at http://www.quickvba.blogspot.com http://www.quickvba.blogspot.com/ 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com http://exceldailytip.blogspot.com/ To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel -- Regards Ashish Koul http://akoul.blogspot.com/ akoul.blogspot.com http://akoul.wordpress.com/ akoul.wordpress.com My http://in.linkedin.com/pub/ashish-koul/10/400/830 Linkedin Profile P Before printing, think about the environment. -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com http://www.excel-macros.blogspot.com/ 4. Learn VBA Macros at http://www.quickvba.blogspot.com http://www.quickvba.blogspot.com/ 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com http://exceldailytip.blogspot.com/ To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
Re: $$Excel-Macros$$ Recovering corrupted excel file
Hi, Its a confidential file. I cannot send the file. Please let me know if there a way to recover the file. Regards, Chandra Shekar B On Tue, May 24, 2011 at 2:35 PM, Rajan_Verma rajanverma1...@gmail.comwrote: Send your File.. *From:* excel-macros@googlegroups.com [mailto: excel-macros@googlegroups.com] *On Behalf Of *Chandra Shekar *Sent:* Monday, May 23, 2011 11:33 AM *To:* excel-macros@googlegroups.com *Subject:* Re: $$Excel-Macros$$ Recovering corrupted excel file Hi, This I tried but still I could not able to recover the file. Let me know is there any other way to recover file. Thanks, Chandra Shekar B On Sat, May 21, 2011 at 10:11 AM, ashish koul koul.ash...@gmail.com wrote: http://office.microsoft.com/en-us/excel-help/repairing-corrupted-files-in-excel-HA001034656.aspx On Fri, May 20, 2011 at 5:13 PM, Chandra Shekar chandrashekarb@gmail.com wrote: Hi can u expalin briefly in steps. Thanks, Chandra Shekar B On Fri, May 20, 2011 at 5:02 PM, rajan verma rajanverma1...@gmail.com wrote: Use a Function Like this ='C:\Users\Xl_Lover\Desktop\[Book2[Sheet1]]Index'!A1 On Fri, May 20, 2011 at 4:00 PM, Chandra Shekar chandrashekarb@gmail.com wrote: Hi, Is there any way to recover corrupted excel file. Thanks, Chandra Shekar B -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel -- Regards Rajan verma +91 9158998701 -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel -- *Regards* * * *Ashish Koul* *akoul*.*blogspot*.com http://akoul.blogspot.com/ *akoul*.wordpress.com http://akoul.wordpress.com/ My Linkedin Profile http://in.linkedin.com/pub/ashish-koul/10/400/830 P Before printing, think about the environment. -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links :
Re: $$Excel-Macros$$ Recovering corrupted excel file
See if it help http://www.ozgrid.com/Excel/scenarios.htm On Tue, May 24, 2011 at 2:50 PM, Manoj Kumar kmrmanoj1...@gmail.com wrote: Dear experts Can you tell me what is use of snerios in excel. Regards Manoj On 5/24/11, Rajan_Verma rajanverma1...@gmail.com wrote: Send your File.. From: excel-macros@googlegroups.com [mailto: excel-macros@googlegroups.com] On Behalf Of Chandra Shekar Sent: Monday, May 23, 2011 11:33 AM To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ Recovering corrupted excel file Hi, This I tried but still I could not able to recover the file. Let me know is there any other way to recover file. Thanks, Chandra Shekar B On Sat, May 21, 2011 at 10:11 AM, ashish koul koul.ash...@gmail.com wrote: http://office.microsoft.com/en-us/excel-help/repairing-corrupted-files-in-ex cel-HA001034656.aspx On Fri, May 20, 2011 at 5:13 PM, Chandra Shekar chandrashekarb@gmail.com wrote: Hi can u expalin briefly in steps. Thanks, Chandra Shekar B On Fri, May 20, 2011 at 5:02 PM, rajan verma rajanverma1...@gmail.com wrote: Use a Function Like this ='C:\Users\Xl_Lover\Desktop\[Book2[Sheet1]]Index'!A1 On Fri, May 20, 2011 at 4:00 PM, Chandra Shekar chandrashekarb@gmail.com wrote: Hi, Is there any way to recover corrupted excel file. Thanks, Chandra Shekar B -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com http://www.excel-macros.blogspot.com/ 4. Learn VBA Macros at http://www.quickvba.blogspot.com http://www.quickvba.blogspot.com/ 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com http://exceldailytip.blogspot.com/ To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel -- Regards Rajan verma +91 9158998701 -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com http://www.excel-macros.blogspot.com/ 4. Learn VBA Macros at http://www.quickvba.blogspot.com http://www.quickvba.blogspot.com/ 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com http://exceldailytip.blogspot.com/ To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com http://www.excel-macros.blogspot.com/ 4. Learn VBA Macros at http://www.quickvba.blogspot.com http://www.quickvba.blogspot.com/ 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com http://exceldailytip.blogspot.com/ To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel -- Regards Ashish Koul http://akoul.blogspot.com/ akoul.blogspot.com http://akoul.wordpress.com/ akoul.wordpress.com My http://in.linkedin.com/pub/ashish-koul/10/400/830 Linkedin Profile P Before printing, think about the environment. -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com http://www.excel-macros.blogspot.com/ 4. Learn VBA Macros at http://www.quickvba.blogspot.com http://www.quickvba.blogspot.com/ 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com http://exceldailytip.blogspot.com/ To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel -- -- Some important links for
Re: $$Excel-Macros$$ Need a formula for getting the output of one calculation as RATIO
Paste this Function into your Excel VBE and then use this in Worksheet =Ratio2(Value1,Value2,Value3) On Tue, May 24, 2011 at 2:12 PM, Kabir:-) saroj.32...@gmail.com wrote: Dear Rajan, I would be thank ful for your help. But I m not getting how exactly to run this VBA code in my required Excell Work Book. Can u help me...? Regards, Saroj On Mon, May 23, 2011 at 8:20 PM, rajan verma rajanverma1...@gmail.comwrote: Amended.. Function Ratio2(*ParamArray* arr()) As String For i = 0 To UBound(arr) Ratio2 = Ratio2 arr(i) / WorksheetFunction.Gcd(arr) : Next Ratio2 = Left(Ratio2, Len(Ratio2) - 1) End Function On Mon, May 23, 2011 at 8:16 PM, rajan verma rajanverma1...@gmail.comwrote: *Try this Function* Function Ratio2(*ParamArray* arr()) As String Dim Arr2(1) As Integer For i = 0 To UBound(arr) Ratio2 = Ratio2 arr(i) / WorksheetFunction.Gcd(arr) : Next Ratio2 = Left(Ratio2, Len(Ratio2) - 1) End Function On Mon, May 23, 2011 at 12:35 PM, Kabir:-) saroj.32...@gmail.comwrote: Dear Rajan, Thanks for your formulait works. But I want to know, will there be any macro or VBA code for the query like this. Kindly help me if anything available like such. Thank you all... Regards, Saroj. On Sat, May 21, 2011 at 10:00 AM, Rajan_Verma rajanverma1...@gmail.com wrote: Hi Kabir, See if it help. *From:* excel-macros@googlegroups.com [mailto: excel-macros@googlegroups.com] *On Behalf Of *Kabir:-) *Sent:* Friday, May 20, 2011 5:09 PM *To:* excel-macros@googlegroups.com *Subject:* $$Excel-Macros$$ Need a formula for getting the output of one calculation as RATIO Dear Gurus, I need a formula for calculated two numbers and resulted output should be in a Ratio.i.e., 2:1 or 1.5:3. Thank you in advance, Regards, Saroj. -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel -- Regards Rajan verma +91 9158998701 -- Regards Rajan verma +91 9158998701 -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at
Re: $$Excel-Macros$$ Simple VBA code for filter data in ascending
yes Sorting On Fri, May 20, 2011 at 5:41 PM, STDEV(i) setiyowati.d...@gmail.com wrote: do you mean SORTING ? Ascending / descending order are parameters of SORTING action not Filtering.. CMIIW On Fri, May 20, 2011 at 2:57 PM, Deepak Rawat deepakexce...@gmail.comwrote: Hi All I need the simplest VBA code to filter any data in ascending. Regards, Deepak -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel
Re: $$Excel-Macros$$ Need a formula for getting the output of one calculation as RATIO
Dear rajan, thanks for your help.the functions works well. Regards, Saroj. On Tue, May 24, 2011 at 5:20 PM, rajan verma rajanverma1...@gmail.comwrote: Paste this Function into your Excel VBE and then use this in Worksheet =Ratio2(Value1,Value2,Value3) On Tue, May 24, 2011 at 2:12 PM, Kabir:-) saroj.32...@gmail.comwrote: Dear Rajan, I would be thank ful for your help. But I m not getting how exactly to run this VBA code in my required Excell Work Book. Can u help me...? Regards, Saroj On Mon, May 23, 2011 at 8:20 PM, rajan verma rajanverma1...@gmail.comwrote: Amended.. Function Ratio2(*ParamArray* arr()) As String For i = 0 To UBound(arr) Ratio2 = Ratio2 arr(i) / WorksheetFunction.Gcd(arr) : Next Ratio2 = Left(Ratio2, Len(Ratio2) - 1) End Function On Mon, May 23, 2011 at 8:16 PM, rajan verma rajanverma1...@gmail.comwrote: *Try this Function* Function Ratio2(*ParamArray* arr()) As String Dim Arr2(1) As Integer For i = 0 To UBound(arr) Ratio2 = Ratio2 arr(i) / WorksheetFunction.Gcd(arr) : Next Ratio2 = Left(Ratio2, Len(Ratio2) - 1) End Function On Mon, May 23, 2011 at 12:35 PM, Kabir:-) saroj.32...@gmail.comwrote: Dear Rajan, Thanks for your formulait works. But I want to know, will there be any macro or VBA code for the query like this. Kindly help me if anything available like such. Thank you all... Regards, Saroj. On Sat, May 21, 2011 at 10:00 AM, Rajan_Verma rajanverma1...@gmail.com wrote: Hi Kabir, See if it help. *From:* excel-macros@googlegroups.com [mailto: excel-macros@googlegroups.com] *On Behalf Of *Kabir:-) *Sent:* Friday, May 20, 2011 5:09 PM *To:* excel-macros@googlegroups.com *Subject:* $$Excel-Macros$$ Need a formula for getting the output of one calculation as RATIO Dear Gurus, I need a formula for calculated two numbers and resulted output should be in a Ratio.i.e., 2:1 or 1.5:3. Thank you in advance, Regards, Saroj. -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel -- Regards Rajan verma +91 9158998701 -- Regards Rajan verma +91 9158998701 -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @
$$Excel-Macros$$ Macro to Enter Current Time and Date
Sub NOWENTRY() ' Please help with my macro to enter current time and date into any cell I choose. It always goes back to the cell in the macro and I want it to work for the current cell the cursor is sitting on when I hit Ctrl+n. My Macro: ' NOWENTRY Macro ' Enters current time and date ' ' Keyboard Shortcut: Ctrl+n ' Range(B5029).Select ActiveCell.FormulaR1C1 = =NOW() Range(B5029).Select Selection.Copy Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks _ :=False, Transpose:=False End Sub Thank you again for your help. John -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel
$$Excel-Macros$$ Pivot Items
Hi, How to extract data from a pivot item. In the example I need pivot items(1) data in the same worksheet. Thanks! With pvt_tbl pvt_tbl.PivotFields(Priority).PivotItems(1).Visible = True pvt_tbl.PivotFields(Priority).PivotItems(2).Visible = False pvt_tbl.PivotFields(Priority).PivotItems(3).Visible = False pvt_tbl.PivotFields(Priority).PivotItems(4).Visible = False End With -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel
$$Excel-Macros$$ Seperate the data in proper fomat
Hi Friends, I have to seperate the data in proper formatting, Pls suggest the best worksheet is attached. Regards, Deepak -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel How to seperate the data.xlsb Description: Binary data
Re: $$Excel-Macros$$ Macro to Enter Current Time and Date
try this Sub test() Range(B5029).Value = Now() End Sub On Tue, May 24, 2011 at 8:39 PM, John A. Smith johnasmit...@gmail.comwrote: Sub NOWENTRY() ' Please help with my macro to enter current time and date into any cell I choose. It always goes back to the cell in the macro and I want it to work for the current cell the cursor is sitting on when I hit Ctrl+n. My Macro: ' NOWENTRY Macro ' Enters current time and date ' ' Keyboard Shortcut: Ctrl+n ' Range(B5029).Select ActiveCell.FormulaR1C1 = =NOW() Range(B5029).Select Selection.Copy Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks _ :=False, Transpose:=False End Sub Thank you again for your help. John -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel -- *Regards* * * *Ashish Koul* *akoul*.*blogspot*.com http://akoul.blogspot.com/ http://akoul.posterous.com/ *akoul*.wordpress.com http://akoul.wordpress.com/ My Linkedin Profile http://in.linkedin.com/pub/ashish-koul/10/400/830 P Before printing, think about the environment. -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel
Re: $$Excel-Macros$$ Seperate the data in proper fomat
try this Function companyname(x As String) Dim s As String For i = 1 To Len(x) If Asc(Mid(x, i, 1)) = 48 And Asc(Mid(x, i, 1)) = 57 Then Exit For Else s = s Mid(x, i, 1) End If Next i companyname = s End Function On Tue, May 24, 2011 at 6:07 PM, Deepak Rawat deepakexce...@gmail.comwrote: Hi Friends, I have to seperate the data in proper formatting, Pls suggest the best worksheet is attached. Regards, Deepak -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel -- *Regards* * * *Ashish Koul* *akoul*.*blogspot*.com http://akoul.blogspot.com/ http://akoul.posterous.com/ *akoul*.wordpress.com http://akoul.wordpress.com/ My Linkedin Profile http://in.linkedin.com/pub/ashish-koul/10/400/830 P Before printing, think about the environment. -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel
$$Excel-Macros$$ Repost: Excel initiating export from Crystal report
I know how to export a Crystal report to Excel from the Crystal Viewer. Is it possible to initiate that from an Excel file? That is, given a Crystal report, can Excel run a VB script or some other function to export the data from the Crystal report without me using the Viewer at all? I'm not a user of Crystal other than using the Viewer but I do know Excel very well. Thanks so much! -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel
$$Excel-Macros$$ set returned RGB values differ
I have code which does this: Color_A as long, Color_B as long Color_A=RGB(186,85,211) .. activecell.interior.color=RGB(186,85,211) Color_B=activecell.interior.color The result is Color_A = 13850042 but Color_B = 16751052 Can anyone explain? Is there a workaround? -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel
$$Excel-Macros$$ How to filter only the required information using VBA codes?
Friends, I am sitting with a simple problem. Given the info below, i want to use vba codes to inset a filter and filter out only the following times and it doesn't matter what which day of the month it is; 11:00, 11;30, 19:00, 19:30, 20:00, 20:30, 21:00, 21:30, 22:00 and 22:30. Start Time 05/22/2011 00:00:00 05/22/2011 00:30:00 05/22/2011 01:00:00 05/22/2011 01:30:00 05/22/2011 02:00:00 05/22/2011 02:30:00 05/22/2011 03:00:00 05/22/2011 03:30:00 05/22/2011 04:00:00 05/22/2011 04:30:00 05/22/2011 05:00:00 05/22/2011 05:30:00 05/22/2011 06:00:00 05/22/2011 06:30:00 05/22/2011 07:00:00 05/22/2011 07:30:00 05/22/2011 08:00:00 05/22/2011 08:30:00 05/22/2011 09:00:00 05/22/2011 09:30:00 05/22/2011 10:00:00 05/22/2011 10:30:00 05/22/2011 11:00:00 05/22/2011 11:30:00 05/22/2011 12:00:00 05/22/2011 12:30:00 05/22/2011 13:00:00 05/22/2011 13:30:00 05/22/2011 14:00:00 05/22/2011 14:30:00 05/22/2011 15:00:00 05/22/2011 15:30:00 05/22/2011 16:00:00 05/22/2011 16:30:00 05/22/2011 17:00:00 05/22/2011 17:30:00 05/22/2011 18:00:00 05/22/2011 18:30:00 05/22/2011 19:00:00 05/22/2011 19:30:00 05/22/2011 20:00:00 05/22/2011 20:30:00 05/22/2011 21:00:00 05/22/2011 21:30:00 05/22/2011 22:00:00 05/22/2011 22:30:00 05/22/2011 23:00:00 05/22/2011 23:30:00 Awaiting for your earliest reply best regards, John This e-mail message and any attachment hereto are confidential information intended for a specific addressee and purpose. If you are not the intended recipient, or a person responsible for delivering it to the intended recipient, you may not disclose, copy, distribute or take any action based on the contents hereof, or retaining this message or any part of it, in any form whatsoever. Any such conduct is prohibited and may be unlawful. If you have received this e-mail in error, please notify the sender immediately by replying to this message and destroy all copies hereof. No opinion expressed by the sender necessarily constitutes the opinion of Mobile Telecommunications Ltd (MTC). This message does not constitute a guarantee or proof of the facts mentioned herein. No employee or intermediary is authorized to conclude a binding agreement on behalf of MTC by e-mail without the express written confirmation by a duly authorized representative of MTC. All reasonable precautions have been taken to ensure a virus free message however, MTC cannot guarantee this nor accept responsibility whatsoever for loss or damage arising from the use of this e-mail or attachments. MTC reserve the right to monitor all e-mail communications transmitted through our network. -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel
Re: $$Excel-Macros$$ Macro to Enter Current Time and Date
jus delete Range(B5029).Select so your macro will b like this. you have recorded this macro. record it again but just delete that Range thing ' NOWENTRY Macro ' Enters current time and date ' ' Keyboard Shortcut: Ctrl+n ' ActiveCell.FormulaR1C1 = =NOW() Selection.Copy Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks _ :=False, Transpose:=False End Sub From: John A. Smith johnasmit...@gmail.com To: excel-macros@googlegroups.com Sent: Tue, 24 May, 2011 4:09:51 PM Subject: $$Excel-Macros$$ Macro to Enter Current Time and Date Sub NOWENTRY() ' Please help with my macro to enter current time and date into any cell I choose. It always goes back to the cell in the macro and I want it to work for the current cell the cursor is sitting on when I hit Ctrl+n. My Macro: ' NOWENTRY Macro ' Enters current time and date ' ' Keyboard Shortcut: Ctrl+n ' Range(B5029).Select ActiveCell.FormulaR1C1 = =NOW() Range(B5029).Select Selection.Copy Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks _ :=False, Transpose:=False End Sub Thank you again for your help. John-- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel
Re: $$Excel-Macros$$ Simple VBA code for filter data in ascending
Try this...with a command button, Change your range as needed, this one is A2:B1 Private Sub CommandButton2_Click() ActiveWorkbook.Worksheets(Your Worksheet Name).Sort.SortFields.Clear ActiveWorkbook.Worksheets(Your Worksheet Name).Sort.SortFields.Add Key _ :=Range(A2), SortOn:=xlSortOnValues, Order:=xlAscending, DataOption:= _ xlSortNormal With ActiveWorkbook.Worksheets(Your Worksheet Name).Sort .SetRange Range(A2:B1) .Header = xlNo .MatchCase = False .Orientation = xlTopToBottom .SortMethod = xlPinYin .Apply End With End Sub On May 24, 7:44 am, Deepak Rawat deepakexce...@gmail.com wrote: yes Sorting On Fri, May 20, 2011 at 5:41 PM, STDEV(i) setiyowati.d...@gmail.com wrote: do you mean SORTING ? Ascending / descending order are parameters of SORTING action not Filtering.. CMIIW On Fri, May 20, 2011 at 2:57 PM, Deepak Rawat deepakexce...@gmail.comwrote: Hi All I need the simplest VBA code to filter any data in ascending. Regards, Deepak -- ------ Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials athttp://www.excel-macros.blogspot.com 4. Learn VBA Macros athttp://www.quickvba.blogspot.com 5. Excel Tips and Tricks athttp://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel- Hide quoted text - - Show quoted text - -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel
Re: $$Excel-Macros$$ Macro to Enter Current Time and Date
Excellent! Thank you very Much! John On Tue, May 24, 2011 at 11:44 AM, ashish koul koul.ash...@gmail.com wrote: try this Sub test() ActiveCell.Value = Now() End Sub or Sub test() Range(B5029).Value = Now() End Sub On Tue, May 24, 2011 at 8:39 PM, John A. Smith johnasmit...@gmail.comwrote: Sub NOWENTRY() ' Please help with my macro to enter current time and date into any cell I choose. It always goes back to the cell in the macro and I want it to work for the current cell the cursor is sitting on when I hit Ctrl+n. My Macro: ' NOWENTRY Macro ' Enters current time and date ' ' Keyboard Shortcut: Ctrl+n ' Range(B5029).Select ActiveCell.FormulaR1C1 = =NOW() Range(B5029).Select Selection.Copy Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks _ :=False, Transpose:=False End Sub Thank you again for your help. John -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel -- *Regards* * * *Ashish Koul* *akoul*.*blogspot*.com http://akoul.blogspot.com/ http://akoul.posterous.com/ *akoul*.wordpress.com http://akoul.wordpress.com/ My Linkedin Profile http://in.linkedin.com/pub/ashish-koul/10/400/830 P Before printing, think about the environment. -- *Regards* * * *Ashish Koul* *akoul*.*blogspot*.com http://akoul.blogspot.com/ http://akoul.posterous.com/ *akoul*.wordpress.com http://akoul.wordpress.com/ My Linkedin Profile http://in.linkedin.com/pub/ashish-koul/10/400/830 P Before printing, think about the environment. -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel
$$Excel-Macros$$ Re: Macro to Enter Current Time and Date
Not sure if this will help but here a 2 different ways. Both will keep date from changing the next day. You can create a circular referance with this formula =IF(B3=,,IF(C3=,NOW(),C3)) Or this will put the date in Column C using a macro Private Sub Worksheet_Change(ByVal Target As Range) If Target.Count 1 Then Exit Sub If Target.Row = 1 Then Exit Sub If Target.Column = 1 And Target.Column = 2 Then If Application.CountA(Cells(Target.Row, 1).Resize(, 2)) = 2 _ And IsEmpty(Cells(Target.Row, 3)) Then Cells(Target.Row, 3).Value = Date End If End If End Sub On May 24, 11:09 am, John A. Smith johnasmit...@gmail.com wrote: Sub NOWENTRY() ' Please help with my macro to enter current time and date into any cell I choose. It always goes back to the cell in the macro and I want it to work for the current cell the cursor is sitting on when I hit Ctrl+n. My Macro: ' NOWENTRY Macro ' Enters current time and date ' ' Keyboard Shortcut: Ctrl+n ' Range(B5029).Select ActiveCell.FormulaR1C1 = =NOW() Range(B5029).Select Selection.Copy Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks _ :=False, Transpose:=False End Sub Thank you again for your help. John -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel
Re: $$Excel-Macros$$ Simple VBA code for filter data in ascending
try this http://akoul.blogspot.com/search/label/Sort%20data%20in%20vba On Wed, May 25, 2011 at 4:16 AM, Bob bobandrich...@comcast.net wrote: Try this...with a command button, Change your range as needed, this one is A2:B1 Private Sub CommandButton2_Click() ActiveWorkbook.Worksheets(Your Worksheet Name).Sort.SortFields.Clear ActiveWorkbook.Worksheets(Your Worksheet Name).Sort.SortFields.Add Key _ :=Range(A2), SortOn:=xlSortOnValues, Order:=xlAscending, DataOption:= _ xlSortNormal With ActiveWorkbook.Worksheets(Your Worksheet Name).Sort .SetRange Range(A2:B1) .Header = xlNo .MatchCase = False .Orientation = xlTopToBottom .SortMethod = xlPinYin .Apply End With End Sub On May 24, 7:44 am, Deepak Rawat deepakexce...@gmail.com wrote: yes Sorting On Fri, May 20, 2011 at 5:41 PM, STDEV(i) setiyowati.d...@gmail.com wrote: do you mean SORTING ? Ascending / descending order are parameters of SORTING action not Filtering.. CMIIW On Fri, May 20, 2011 at 2:57 PM, Deepak Rawat deepakexce...@gmail.com wrote: Hi All I need the simplest VBA code to filter any data in ascending. Regards, Deepak -- ------ Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials athttp://www.excel-macros.blogspot.com 4. Learn VBA Macros athttp://www.quickvba.blogspot.com 5. Excel Tips and Tricks athttp://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel- Hide quoted text - - Show quoted text - -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel -- *Regards* * * *Ashish Koul* *akoul*.*blogspot*.com http://akoul.blogspot.com/ http://akoul.posterous.com/ *akoul*.wordpress.com http://akoul.wordpress.com/ My Linkedin Profile http://in.linkedin.com/pub/ashish-koul/10/400/830 P Before printing, think about the environment. -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel
