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 wrote:
> Experts,
> Pls find the atta
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 wrote:
> Sub Macro1()
> If ActiveSheet.A
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,
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").AutoFilte
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
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 opt
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 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, R
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 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
>
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.
onc
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 wrote:
> HI
>
> use it ony if you are not using any background colors in file
>
>
> code:
> Private Sub Worksheet_SelectionChange(
> ByVal Target As Range)
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 wrote:
> check
check the attachment see if that solves your problem
On Mon, Oct 25, 2010 at 8:02 PM, Rajesh K R 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
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
13 matches
Mail list logo
