$$Excel-Macros$$ Re: Filter Problem in Excel 2003
Mr Ramesh, I think the filter drop down list has a limitiation of 1000 entries in excel 2003 which might be extended to a bigger number in excel 2007. Again the dropdowns are re-populated when filter is set on a column. For example, I filtered on 'Customer No' column for Nov-10, it got out 'deposit date' drop down values '1-nov-2010'. What is understand is: When, working with filter in a workbook (excel 2003) having more than 1000 rows, if the criterias in a particular column also exceeds 1000 (like deposit date), then it is better to break it into two columns. Break the Deposit date into two columns, ie Deposit Month and Deposit Date. For filtering on a particular date, first filter on particular month and then select the date. Regards, Kishan Reddy, K . On Nov 7, 7:44 pm, Ramkesh Maurya sunscel...@gmail.com wrote: Dear all, I am facing a problem in filter (in column N) when I use Excel 2003. There is a date 1-Nov-2010 which is not appearing in the Auto Filter option although when I deleted blank cell but this is appearing when i sorted in asc/descind order In Excel 2007 this is appearing. I have attached the file. Thanks for any suggestion -- Ramkesh 9990260398 PDC TRACKER - SOUTH.zip 2274KViewDownload -- -- 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/pages/discussexcelcom/160307843985936?v=wallref=ts
Re: $$Excel-Macros$$ Delete rows including blank row except few members
Hi Hari, Just Insert the Code in VBA Module, Like, press Alt+F11, VBA window will open, then, just from the menu bar, Insert , Module, there you will place the code. Here is a link: www.contextures.com/xlvba01.html http://www.contextures.com/xlvba01.htmlKeep Smiling, On Mon, Nov 8, 2010 at 9:07 AM, Hari Lal. C harilal@gmail.com wrote: HLC Dear Krishna Mummina, I saw yr solution to the question of Niel Johnson. As i am a primary student in Excel I don't know how to create Excel Macro. I would like to know how to apply these commands in excel and how to use it. Shall I except yr kind help. Kindly enlighten me using or applying the following commands step by step in excel. delete the entire row when specification meets Sub processdata() Dim i As Long, lr As Long lr = ActiveSheet.UsedRange.Rows.Count Application.ScreenUpdating = False For i = 1 To lr If Range(A i).Value = Then Range(A i).EntireRow.Delete If UCase(Range(A i).Value) = C Then Range(A i).EntireRow.Delete If UCase(Range(A i).Value) = D Then Range(A i).EntireRow.Delete If UCase(Range(A i).Value) = E Then Range(A i).EntireRow.Delete If UCase(Range(A i).Value) = F Then Range(A i).EntireRow.Delete Next Application.ScreenUpdating = True End Sub Hari Lal -- -- 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/pages/discussexcelcom/160307843985936?v=wallref=ts -- -- 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/pages/discussexcelcom/160307843985936?v=wallref=ts
$$Excel-Macros$$ Re: How to change multiple values
You can change Manually... Do F2 then = existing value * 40% Else through macro it can easily possible On Nov 8, 10:36 am, Vaaibhav vaaibhavjhav...@gmail.com wrote: Hello All Is there any shortcut for changing values in various cells (same column) to a same multiplier. I am just elaborationg - say in Column A i have 4, 5, 6, 10 written in first four rows. I want to change these values to 40% in a single shot. Is that possible? I dont want to copy and paste the column and then calculate etc. Pls help if this is having a solution. Regards Vaaibhav -- -- 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/pages/discussexcelcom/160307843985936?v=wallref=ts
$$Excel-Macros$$ Excel VBA Macros eBook ..Absolutely FREE worth $45
Dear Group Members, Good news for all of you !! Now you can download VBA macros ebook worth $45 for free. Here is the link to download :- http://recordexcelmacro.com/discussexcel.html I have talked to John Franco (Author) to get this eBook for our group. Please do not miss the chance to download the eBook. This eBook has 140 pages of valuable knowledge on recording macros and customize them. I am working with John to get more resources for you either free or paid.Keep watching this space. Feel free to forward this link and email to all your friends, coworkers and followers. So what are you waiting for...Download it now.. Thanks. Best regards, Ayush Jain Microsoft MVP 2010 -- -- 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/pages/discussexcelcom/160307843985936?v=wallref=ts
Re: $$Excel-Macros$$ Excel VBA Macros eBook ..Absolutely FREE worth $45
Thank you so much Ayush:) On Mon, Nov 8, 2010 at 6:05 AM, Ayush jainayus...@gmail.com wrote: Dear Group Members, Good news for all of you !! Now you can download VBA macros ebook worth $45 for free. Here is the link to download :- http://recordexcelmacro.com/discussexcel.html I have talked to John Franco (Author) to get this eBook for our group. Please do not miss the chance to download the eBook. This eBook has 140 pages of valuable knowledge on recording macros and customize them. I am working with John to get more resources for you either free or paid.Keep watching this space. Feel free to forward this link and email to all your friends, coworkers and followers. So what are you waiting for...Download it now.. Thanks. Best regards, Ayush Jain Microsoft MVP 2010 -- -- 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/pages/discussexcelcom/160307843985936?v=wallref=ts -- -- 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/pages/discussexcelcom/160307843985936?v=wallref=ts
$$Excel-Macros$$ array sort issue
In an attempt to develop my own sort for an array, I seem to have run into a problem. I don't know what I 'm doing wrong specifically, but as soon as I attempt to invoke the Len Function, the whole thing breaks. subscript out of range error. I think I may be overthinking this, so any guidance is much appreciated. Public Function arraySortByStringLength(ary As Variant) Dim iLoc As Long, iLen As Integer, iAry As Variant, i As Long Dim val As String, indx As Long iLen = ReDim iAry(UBound(ary)) i = 0 indx = 0 Do For iLoc = 0 To UBound(ary) If Len(ary(iLoc)) iLen Then iLen = Excel.WorksheetFunction.Len(ary(iLoc)) indx = iLoc val = ary(iLoc) End If Next iLoc iAry(i) = val ReDim Preserve ary(UBound(ary) - 1) ary = arraySlice(ary, indx) i = i + 1 Loop Until UBound(ary) 1 arraySortByStringLength = iAry End Function -- -- 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/pages/discussexcelcom/160307843985936?v=wallref=ts
Re: $$Excel-Macros$$ Excel VBA Macros eBook ..Absolutely FREE worth $45
Thanks, Will always come in handy. Rgds, Chris On Tue, Nov 9, 2010 at 6:49 AM, NOORAIN ANSARI noorain.ans...@gmail.comwrote: Thank u very much Ayush dear... Regards, Noorain On Mon, Nov 8, 2010 at 5:50 PM, Venkat venkat1@gmail.com wrote: Dear Ayush, Thanks a Lot:) *Best Regards,* *Venkat* On Mon, Nov 8, 2010 at 7:35 PM, Ayush jainayus...@gmail.com wrote: Dear Group Members, Good news for all of you !! Now you can download VBA macros ebook worth $45 for free. Here is the link to download :- http://recordexcelmacro.com/discussexcel.html I have talked to John Franco (Author) to get this eBook for our group. Please do not miss the chance to download the eBook. This eBook has 140 pages of valuable knowledge on recording macros and customize them. I am working with John to get more resources for you either free or paid.Keep watching this space. Feel free to forward this link and email to all your friends, coworkers and followers. So what are you waiting for...Download it now.. Thanks. Best regards, Ayush Jain Microsoft MVP 2010 -- -- 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/pages/discussexcelcom/160307843985936?v=wallref=ts -- -- -- 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/pages/discussexcelcom/160307843985936?v=wallref=ts -- Thanks regards, Noorain Ansari -- -- 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/pages/discussexcelcom/160307843985936?v=wallref=ts -- -- 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/pages/discussexcelcom/160307843985936?v=wallref=ts
$$Excel-Macros$$ Re: How to change multiple values
Hello saggi I think you must have given this reply considering that I have only 4 rows to be changed. What if I have 4000 rows to be changed at same point of time? Kindly help if you can. Regards Vaaibhav On Nov 8, 4:51 pm, saggi realsa...@gmail.com wrote: You can change Manually... Do F2 then = existing value * 40% Else through macro it can easily possible On Nov 8, 10:36 am, Vaaibhav vaaibhavjhav...@gmail.com wrote: Hello All Is there any shortcut for changing values in various cells (same column) to a same multiplier. I am just elaborationg - say in Column A i have 4, 5, 6, 10 written in first four rows. I want to change these values to 40% in a single shot. Is that possible? I dont want to copy and paste the column and then calculate etc. Pls help if this is having a solution. Regards Vaaibhav -- -- 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/pages/discussexcelcom/160307843985936?v=wallref=ts