Re: $$Excel-Macros$$ manage lengthy database
Experts, Pls find the attachment and find a solution, in that filter not working properly in the dates except 10/10/2010 11/10/2010, pls tell me the problem help me to solve it. Regards Rajesh kainikkara On 10/30/10, ashish koul koul.ash...@gmail.com wrote: Sub Macro1() If ActiveSheet.AutoFilterMode = True Then ActiveSheet.AutoFilterMode = False End If ActiveSheet.Range($A$1:$B$27).AutoFilter Field:=2, Criteria1:= _ = CDate(Range(g4).Value), Operator:=xlAnd, Criteria2:== CDate(Range(g5).Value) End Sub On Sat, Oct 30, 2010 at 7:12 PM, Rajesh K R rajeshkainikk...@gmail.comwrote: Hi Experts thanks for ur promt reply.is it possible to give the from to dates for filtering in specified cells and filter it by a macro eg: Sub applyfilter() If ActiveSheet.AutoFilterMode = True Then ActiveSheet.AutoFilterMode = False End If ActiveSheet.Range($A$1:$B$27).AutoFilter Field:=2, Criteria1:= _ =$d$1, Operator:=xlAnd, Criteria2:==$e$1 End Sub Regards Rajesh Kainikkara On 10/28/10, ashish koul koul.ash...@gmail.com wrote: Sub applyfilter() If ActiveSheet.AutoFilterMode = True Then ActiveSheet.AutoFilterMode = False End If ActiveSheet.Range($A$1:$B$27).AutoFilter Field:=2, Criteria1:= _ =10/31/2010, Operator:=xlAnd, Criteria2:==11/18/2010 End Sub Sub RemoveFilter() If ActiveSheet.AutoFilterMode = True Then ActiveSheet.AutoFilterMode = False End If End Sub On Thu, Oct 28, 2010 at 4:44 PM, P.VIJAYKUMAR vijay.4...@gmail.com wrote: Hi Rakesh, You can also change gridline colour or give colours to the cells in which you want to see your Cursor.To change thecoulour of gridline(if you are using excel 2007) Go to the Excel ribbon Button then go to the Excel option Button In that go to that advanced option. In that advanced option go to the Display options in that in the end you will have chage gridline Colour.you can select what ever coulour you want excep dark colours because dark clours Mix withthe cursor colour and you will get confused, Regards, VijayKumar On Mon, Oct 25, 2010 at 8:02 PM, Rajesh K R rajeshkainikk...@gmail.comwrote: Hi experts Any one can help me to manage my problem to work in the lengthy database, eg if selected a raw having a lot of field i am mistaken many times to identify the related name field. pls find the attachment regarding the problem help me to find a solution. Expecting your valuable advise Regards Rajesh -- -- 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 -- P.VIJAY KUMAR -- -- 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 -- *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/pages/discussexcelcom/160307843985936?v=wallref=ts --
Re: $$Excel-Macros$$ manage lengthy database
Experts, Pls find the attachment and find a solution, in that filter not working properly in the dates except 10/10/2010 11/10/2010, pls tell me the problem help me to solve it. Regards Rajesh kainikkara On 10/31/10, Rajesh K R rajeshkainikk...@gmail.com wrote: Experts, Pls find the attachment and find a solution, in that filter not working properly in the dates except 10/10/2010 11/10/2010, pls tell me the problem help me to solve it. Regards Rajesh kainikkara On 10/30/10, ashish koul koul.ash...@gmail.com wrote: Sub Macro1() If ActiveSheet.AutoFilterMode = True Then ActiveSheet.AutoFilterMode = False End If ActiveSheet.Range($A$1:$B$27).AutoFilter Field:=2, Criteria1:= _ = CDate(Range(g4).Value), Operator:=xlAnd, Criteria2:== CDate(Range(g5).Value) End Sub On Sat, Oct 30, 2010 at 7:12 PM, Rajesh K R rajeshkainikk...@gmail.comwrote: Hi Experts thanks for ur promt reply.is it possible to give the from to dates for filtering in specified cells and filter it by a macro eg: Sub applyfilter() If ActiveSheet.AutoFilterMode = True Then ActiveSheet.AutoFilterMode = False End If ActiveSheet.Range($A$1:$B$27).AutoFilter Field:=2, Criteria1:= _ =$d$1, Operator:=xlAnd, Criteria2:==$e$1 End Sub Regards Rajesh Kainikkara On 10/28/10, ashish koul koul.ash...@gmail.com wrote: Sub applyfilter() If ActiveSheet.AutoFilterMode = True Then ActiveSheet.AutoFilterMode = False End If ActiveSheet.Range($A$1:$B$27).AutoFilter Field:=2, Criteria1:= _ =10/31/2010, Operator:=xlAnd, Criteria2:==11/18/2010 End Sub Sub RemoveFilter() If ActiveSheet.AutoFilterMode = True Then ActiveSheet.AutoFilterMode = False End If End Sub On Thu, Oct 28, 2010 at 4:44 PM, P.VIJAYKUMAR vijay.4...@gmail.com wrote: Hi Rakesh, You can also change gridline colour or give colours to the cells in which you want to see your Cursor.To change thecoulour of gridline(if you are using excel 2007) Go to the Excel ribbon Button then go to the Excel option Button In that go to that advanced option. In that advanced option go to the Display options in that in the end you will have chage gridline Colour.you can select what ever coulour you want excep dark colours because dark clours Mix withthe cursor colour and you will get confused, Regards, VijayKumar On Mon, Oct 25, 2010 at 8:02 PM, Rajesh K R rajeshkainikk...@gmail.comwrote: Hi experts Any one can help me to manage my problem to work in the lengthy database, eg if selected a raw having a lot of field i am mistaken many times to identify the related name field. pls find the attachment regarding the problem help me to find a solution. Expecting your valuable advise Regards Rajesh -- -- 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 -- P.VIJAY KUMAR -- -- 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 -- *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
Re: $$Excel-Macros$$ manage lengthy database
Sub Macro1() If ActiveSheet.AutoFilterMode = True Then ActiveSheet.AutoFilterMode = False End If ActiveSheet.Range($A$1:$B$27).AutoFilter Field:=2, Criteria1:= _ = CDate(Range(g4).Value), Operator:=xlAnd, Criteria2:== CDate(Range(g5).Value) End Sub On Sat, Oct 30, 2010 at 7:12 PM, Rajesh K R rajeshkainikk...@gmail.comwrote: Hi Experts thanks for ur promt reply.is it possible to give the from to dates for filtering in specified cells and filter it by a macro eg: Sub applyfilter() If ActiveSheet.AutoFilterMode = True Then ActiveSheet.AutoFilterMode = False End If ActiveSheet.Range($A$1:$B$27).AutoFilter Field:=2, Criteria1:= _ =$d$1, Operator:=xlAnd, Criteria2:==$e$1 End Sub Regards Rajesh Kainikkara On 10/28/10, ashish koul koul.ash...@gmail.com wrote: Sub applyfilter() If ActiveSheet.AutoFilterMode = True Then ActiveSheet.AutoFilterMode = False End If ActiveSheet.Range($A$1:$B$27).AutoFilter Field:=2, Criteria1:= _ =10/31/2010, Operator:=xlAnd, Criteria2:==11/18/2010 End Sub Sub RemoveFilter() If ActiveSheet.AutoFilterMode = True Then ActiveSheet.AutoFilterMode = False End If End Sub On Thu, Oct 28, 2010 at 4:44 PM, P.VIJAYKUMAR vijay.4...@gmail.com wrote: Hi Rakesh, You can also change gridline colour or give colours to the cells in which you want to see your Cursor.To change thecoulour of gridline(if you are using excel 2007) Go to the Excel ribbon Button then go to the Excel option Button In that go to that advanced option. In that advanced option go to the Display options in that in the end you will have chage gridline Colour.you can select what ever coulour you want excep dark colours because dark clours Mix withthe cursor colour and you will get confused, Regards, VijayKumar On Mon, Oct 25, 2010 at 8:02 PM, Rajesh K R rajeshkainikk...@gmail.comwrote: Hi experts Any one can help me to manage my problem to work in the lengthy database, eg if selected a raw having a lot of field i am mistaken many times to identify the related name field. pls find the attachment regarding the problem help me to find a solution. Expecting your valuable advise Regards Rajesh -- -- 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 -- P.VIJAY KUMAR -- -- 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 -- *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/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
Re: $$Excel-Macros$$ manage lengthy database
hi Ashish Thanks for ur reply, but i am using windows XP,I coukdn't open the file u send.let me know what to do. Regards Rajesh On 10/28/10, ashish koul koul.ash...@gmail.com wrote: check the attachment for custom filter on dates. in case you are using background colors . On Wed, Oct 27, 2010 at 10:52 PM, Rajesh K R rajeshkainikk...@gmail.comwrote: hi , First of all thanks for your reply u solve my problem very simply,i am very happy to get it solved so fast.in case we are using background colour what we can do in that case.I have one more doubt that is about custom filtering using vba.eg: 1/10/10 to 10/10/10 .if it possible pls write me. once again thanks Regards Rajesh Kainikkara On 10/26/10, ratu elissa masihgadis...@gmail.com wrote: How about when we move the the cursor into row 10 the color of range B10:M10 is yellow thanks On Tue, Oct 26, 2010 at 11:27 AM, ashish koul koul.ash...@gmail.com wrote: HI use it ony if you are not using any background colors in file code: Private Sub Worksheet_SelectionChange( ByVal Target As Range) Columns(2).Interior.ColorIndex = xlNone Cells(ActiveCell.Row, 2).Interior.Color = vbYellow End Sub On Mon, Oct 25, 2010 at 9:32 PM, ashish koul koul.ash...@gmail.com wrote: check the attachment see if that solves your problem On Mon, Oct 25, 2010 at 8:02 PM, Rajesh K R rajeshkainikk...@gmail.comwrote: Hi experts Any one can help me to manage my problem to work in the lengthy database, eg if selected a raw having a lot of field i am mistaken many times to identify the related name field. pls find the attachment regarding the problem help me to find a solution. Expecting your valuable advise Regards Rajesh -- -- 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 -- *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. -- *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/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 -- -- 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
Re: $$Excel-Macros$$ manage lengthy database
Hi Rakesh, You can also change gridline colour or give colours to the cells in which you want to see your Cursor.To change thecoulour of gridline(if you are using excel 2007) Go to the Excel ribbon Button then go to the Excel option Button In that go to that advanced option. In that advanced option go to the Display options in that in the end you will have chage gridline Colour.you can select what ever coulour you want excep dark colours because dark clours Mix withthe cursor colour and you will get confused, Regards, VijayKumar On Mon, Oct 25, 2010 at 8:02 PM, Rajesh K R rajeshkainikk...@gmail.comwrote: Hi experts Any one can help me to manage my problem to work in the lengthy database, eg if selected a raw having a lot of field i am mistaken many times to identify the related name field. pls find the attachment regarding the problem help me to find a solution. Expecting your valuable advise Regards Rajesh -- -- 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 -- P.VIJAY KUMAR -- -- 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$$ manage lengthy database
Sub applyfilter() If ActiveSheet.AutoFilterMode = True Then ActiveSheet.AutoFilterMode = False End If ActiveSheet.Range($A$1:$B$27).AutoFilter Field:=2, Criteria1:= _ =10/31/2010, Operator:=xlAnd, Criteria2:==11/18/2010 End Sub Sub RemoveFilter() If ActiveSheet.AutoFilterMode = True Then ActiveSheet.AutoFilterMode = False End If End Sub On Thu, Oct 28, 2010 at 4:44 PM, P.VIJAYKUMAR vijay.4...@gmail.com wrote: Hi Rakesh, You can also change gridline colour or give colours to the cells in which you want to see your Cursor.To change thecoulour of gridline(if you are using excel 2007) Go to the Excel ribbon Button then go to the Excel option Button In that go to that advanced option. In that advanced option go to the Display options in that in the end you will have chage gridline Colour.you can select what ever coulour you want excep dark colours because dark clours Mix withthe cursor colour and you will get confused, Regards, VijayKumar On Mon, Oct 25, 2010 at 8:02 PM, Rajesh K R rajeshkainikk...@gmail.comwrote: Hi experts Any one can help me to manage my problem to work in the lengthy database, eg if selected a raw having a lot of field i am mistaken many times to identify the related name field. pls find the attachment regarding the problem help me to find a solution. Expecting your valuable advise Regards Rajesh -- -- 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 -- P.VIJAY KUMAR -- -- 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 -- *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/pages/discussexcelcom/160307843985936?v=wallref=ts customfilters example.xlsm Description: Binary data
Re: $$Excel-Macros$$ manage lengthy database
How about when we move the the cursor into row 10 the color of range B10:M10 is yellow thanks On Tue, Oct 26, 2010 at 11:27 AM, ashish koul koul.ash...@gmail.com wrote: HI use it ony if you are not using any background colors in file code: Private Sub Worksheet_SelectionChange( ByVal Target As Range) Columns(2).Interior.ColorIndex = xlNone Cells(ActiveCell.Row, 2).Interior.Color = vbYellow End Sub On Mon, Oct 25, 2010 at 9:32 PM, ashish koul koul.ash...@gmail.comwrote: check the attachment see if that solves your problem On Mon, Oct 25, 2010 at 8:02 PM, Rajesh K R rajeshkainikk...@gmail.comwrote: Hi experts Any one can help me to manage my problem to work in the lengthy database, eg if selected a raw having a lot of field i am mistaken many times to identify the related name field. pls find the attachment regarding the problem help me to find a solution. Expecting your valuable advise Regards Rajesh -- -- 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 -- *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. -- *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/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
Re: $$Excel-Macros$$ manage lengthy database
check the attachment see if that solves your problem On Mon, Oct 25, 2010 at 8:02 PM, Rajesh K R rajeshkainikk...@gmail.comwrote: Hi experts Any one can help me to manage my problem to work in the lengthy database, eg if selected a raw having a lot of field i am mistaken many times to identify the related name field. pls find the attachment regarding the problem help me to find a solution. Expecting your valuable advise Regards Rajesh -- -- 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 -- *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/pages/discussexcelcom/160307843985936?v=wallref=ts test111.xlsm Description: Binary data
Re: $$Excel-Macros$$ manage lengthy database
HI use it ony if you are not using any background colors in file code: Private Sub Worksheet_SelectionChange( ByVal Target As Range) Columns(2).Interior.ColorIndex = xlNone Cells(ActiveCell.Row, 2).Interior.Color = vbYellow End Sub On Mon, Oct 25, 2010 at 9:32 PM, ashish koul koul.ash...@gmail.com wrote: check the attachment see if that solves your problem On Mon, Oct 25, 2010 at 8:02 PM, Rajesh K R rajeshkainikk...@gmail.comwrote: Hi experts Any one can help me to manage my problem to work in the lengthy database, eg if selected a raw having a lot of field i am mistaken many times to identify the related name field. pls find the attachment regarding the problem help me to find a solution. Expecting your valuable advise Regards Rajesh -- -- 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 -- *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. -- *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/pages/discussexcelcom/160307843985936?v=wallref=ts