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.com>wrote:
> 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.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
> >>>
> >>
> >>
> >>
> >> --
> >>
> >>
> >>
> >>
> >>
> >>
> >>
> >>
> >>
> >> 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=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
>
--
*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
