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.com>wrote: > >> 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.com>wrote: >> >>> >> >>>> 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=wall&ref=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=wall&ref=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=wall&ref=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=wall&ref=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=wall&ref=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=wall&ref=ts