Closed Thread
Results 1 to 2 of 2

Select next cell in Filter automatically by Excel Macro

  1. #1
    Registered User
    Join Date
    10-07-2009
    Location
    Chennai
    MS-Off Ver
    Excel 2003
    Posts
    6

    Select next cell in Filter automatically by Excel Macro

    Hi

    I need to select next cell from Heading when filter is using. I have recorded the macro but it has been selected range only.

    Macro

    Selection.AutoFilter Field:=2, Criteria1:="="
    Range("C3").Select

    what is code for select next cell after heading instead of Range.

    Thanks in advance.

    Regards,
    M.G.SEKAR

  2. #2
    Forum Guru DonkeyOte's Avatar
    Join Date
    10-22-2008
    Location
    Northumberland, UK
    MS-Off Ver
    O365
    Posts
    21,531

    Re: Select next cell in Filter automatically by Excel Macro

    This is a duplicate post and as such does not comply with Rule 5 of our forum rules. This thread will now be closed, you may continue in your other thread.

    Thread Closed.


    sekar, this is not the first time you've done this today - should you continue to disregard the Rules to which you agreed on registering then I'm afraid your account will be suspended.

    and you're still not using CODE tags...

Closed Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1