If you have cell b9 selected,
do you want the value in this cell
to be used for the filter of column 14, or column 9
(the column of the selected cell)?
also, by using:
activesheet.Range("$A$3:$IX$681")
you're not allowing for any changes to the number of rows.
I would use:
Selection.AutoFilter field:=14, Criteria1:= ActiveCell.value
don't use the quotes around "ActiveCell.Value"
because that say use the WORD "ActiveCell.Value"
and not the VALUE of the active cell.
check my previous suggestion.
if you want the selected cell to be filtered in the
selected column, then use:
Selection.AutoFilter field:= activecell.column, criteria1:= activecell.value
Paul
________________________________
From: big smile <bigsmile...@gmail.com>
To: excel-macros@googlegroups.com
Sent: Fri, June 11, 2010 1:11:41 AM
Subject: Re: $$Excel-Macros$$ MACRO WHICH CAN FILTER THE CURRENT CELL
Thanks for immediate reply.
My 2 nd question solved about print screen.
But to the main question still not resolved.
The problem is i want to filter full raw .
for ex. my cursor is on Raw No. 9 Cell no. B - i.e. - B9
I want to full raw to filtered .
but it does not work.
I have rewrite my macro as following Kindly give check the wordings.
Thanks
Sub Macro2()
'
' Macro2 Macro
' FILTER LIKE THIS
'
' Keyboard Shortcut: Ctrl+Shift+F
'
ActiveSheet.Range("$A$3:$IX$681").AutoFilter field:=14, Criteria1:= _
"ActiveCell.Value "
End Sub
BIG SMILE
SAVLA
On Thu, Jun 10, 2010 at 10:19 PM, ashish koul <koul.ash...@gmail.com> wrote:
>Criteria1:=ActiveCell.Value
>
>
>TO TAKE THE PHOTO PRESS "printscreen" or"prt scr" button and goto ms paint
>press ctrl +v or paste it then cut the image and send it
>
>
>
>
>
>
>
>On Thu, Jun 10, 2010 at 5:00 PM, big smile <bigsmile...@gmail.com> wrote:
>
>Hellow Gorup Masters,
>>
>>I want the help to write the macro as follows.
>>
>>
>>Sub Macro2()
>>'
>>' Macro2 Macro
>>' FILTER LIKE THIS
>>'
>>' Keyboard Shortcut: Ctrl+Shift+F
>>'
>> ActiveSheet.Range("$A$3:$IX$681").AutoFilter Field:=1, Criteria1:= _
>> "CURRENT CELL CONTENT "
>>End Sub
>>
>>
>>when ever i select the particular cell & then press CT+ SFt+ F
>>
>>then what is the data in the current cell from that data the it filters .
>>
>>the longest way is ---
>>
>>1] select the cell
>>
>>2] Use window key or mouse right key - then filter -- select filter by select
>>cell value.
>>
>>I want that to be in the macro
>>
>>I have try - but it does not run properly.
>>
>>one more thing is that i have seen many times in our excel tips that they
>>show the
>>the screen photo -- if i have click right mouse - then again filter option --
>>what is
>>there on the screen - i want to send the same photo on the email to
>>understand
>>
>>better -- how this can be done ?
>>
>>
>>Thanks
>>Savla
>>
>>Have a nice time.
>>
>>
>>
>>
>>
>>
>>
>>
>>
>>
>>
>>--
>>----------------------------------------------------------------------------------
>>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
>>
>><><><><><><><><><><><><><><><><><><><><><><>
>>HELP US GROW !!
>>
>>We reach over 7000 subscribers worldwide and receive many nice notes about
>>the learning and support from the group.Let friends and co-workers know they
>>can subscribe to group at
>>http://groups.google.com/group/excel-macros/subscribe
>>
>--
>----------------------------------------------------------------------------------
>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
>
><><><><><><><><><><><><><><><><><><><><><><>
>HELP US GROW !!
>
>We reach over 7000 subscribers worldwide and receive many nice notes about the
>learning and support from the group.Let friends and co-workers know they can
>subscribe to group at http://groups.google.com/group/excel-macros/subscribe
>
--
----------------------------------------------------------------------------------
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
<><><><><><><><><><><><><><><><><><><><><><>
HELP US GROW !!
We reach over 7000 subscribers worldwide and receive many nice notes about the
learning and support from the group.Let friends and co-workers know they can
subscribe to group at http://groups.google.com/group/excel-macros/subscribe
--
----------------------------------------------------------------------------------
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
<><><><><><><><><><><><><><><><><><><><><><>
HELP US GROW !!
We reach over 7000 subscribers worldwide and receive many nice notes about the
learning and support from the group.Let friends and co-workers know they can
subscribe to group at http://groups.google.com/group/excel-macros/subscribe
