Thanks a lot
Now it has solved.
BIG SMILE
FROM
SAVLA
On Sat, Jun 12, 2010 at 12:53 AM, Paul Schreiner <schreiner_p...@att.net>wrote:
> As I said:
> Use:
> Selection.AutoFilter Field:=ActiveCell.Column,
> Criteria1:=ActiveCell.Value
>
> ------------------------------
> *From:* big smile <bigsmile...@gmail.com>
> *To:* excel-macros@googlegroups.com
> *Sent:* Fri, June 11, 2010 9:32:14 AM
>
> *Subject:* Re: $$Excel-Macros$$ MACRO WHICH CAN FILTER THE CURRENT CELL
>
> Thanks
>
> But my problem is filter *the current cell by raw wise *
>
> I have try your option but i do not get correct soultion.
>
> This time i am attaching the word file what i want to say.
>
> the 1 st page is starting & 2 nd one the soultion.
>
> i am also attaching excel file .
>
>
> Thanks
>
> Have a nice day.
>
> From
> Big Smile
> Savla
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
> On Fri, Jun 11, 2010 at 6:12 PM, Paul Schreiner <schreiner_p...@att.net>wrote:
>
>> 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
>>
>
> --
>
> ----------------------------------------------------------------------------------
> 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
