+ Reply to Thread
Results 1 to 6 of 6

Selecting 2nd to last Visible row in a filtered list

  1. #1
    Registered User
    Join Date
    04-16-2013
    Location
    Bowling Green, OH
    MS-Off Ver
    Excel 2007
    Posts
    3

    Selecting 2nd to last Visible row in a filtered list

    I am trying to write the VBA code to select a cell in the 2nd to last visible row in a filtered list. I can get the cell value in 1st and last row but can't figure out how to move up the list.

    ActiveSheet.AutoFilter.Range.Offset(0).SpecialCells(xlCellTypeVisible).Cells(vEnd, 2).Select

    vEnd = last row
    The 2nd to last row can be anything from 1 to (vEnd-1)

    Thanks in advance
    Paul

  2. #2
    Forum Guru xladept's Avatar
    Join Date
    04-14-2012
    Location
    Pasadena, California
    MS-Off Ver
    Excel 2003,2010
    Posts
    12,378

    Re: Selecting 2nd to last Visible row in a filtered list

    Maybe:

    Please Login or Register  to view this content.
    If I've helped you, please consider adding to my reputation - just click on the liitle star at the left.

    ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~(Pride has no aftertaste.)

    You can't do one thing. XLAdept

    ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~aka Orrin

  3. #3
    Registered User
    Join Date
    04-16-2013
    Location
    Bowling Green, OH
    MS-Off Ver
    Excel 2007
    Posts
    3

    Re: Selecting 2nd to last Visible row in a filtered list

    Selects a hidden row. I was looking for an easy way to avoid looking at each row to determine visible or not in order to select the cell.

  4. #4
    Forum Guru xladept's Avatar
    Join Date
    04-14-2012
    Location
    Pasadena, California
    MS-Off Ver
    Excel 2003,2010
    Posts
    12,378

    Re: Selecting 2nd to last Visible row in a filtered list

    Well then:

    Please Login or Register  to view this content.

  5. #5
    Registered User
    Join Date
    04-16-2013
    Location
    Bowling Green, OH
    MS-Off Ver
    Excel 2007
    Posts
    3

    Re: Selecting 2nd to last Visible row in a filtered list

    Problem solved. Thanks

  6. #6
    Forum Guru xladept's Avatar
    Join Date
    04-14-2012
    Location
    Pasadena, California
    MS-Off Ver
    Excel 2003,2010
    Posts
    12,378

    Re: Selecting 2nd to last Visible row in a filtered list

    You're welcome! And Thanks for the rep

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Rank formula for visible information in filtered list
    By NMullis in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 06-28-2013, 09:14 AM
  2. [SOLVED] Data Validation - using visible rows from filtered list
    By anandvh in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 08-17-2012, 06:14 PM
  3. Replies: 8
    Last Post: 07-14-2012, 10:22 AM
  4. How to sum a filtered list by visible cells only?
    By DorothyFan1 in forum Excel General
    Replies: 2
    Last Post: 10-10-2011, 02:03 PM
  5. Summing the Visible Filtered List Values in Excel 2007
    By ExcelTip in forum Tips and Tutorials
    Replies: 0
    Last Post: 11-27-2007, 07:21 AM

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