Results 1 to 4 of 4

Highest Row from Range that is Visible on Screen

Threaded View

  1. #1
    Valued Forum Contributor ffffloyd's Avatar
    Join Date
    05-20-2008
    Location
    Perth, WA, Australia
    MS-Off Ver
    Office 365
    Posts
    249

    Highest Row from Range that is Visible on Screen

    I am trying to find the highest row that is visible on my screen. It boils down to needing the highest row from a range that is visible or else it will just return my frozen title row. (INFO("origin") will do that.)

    I have tried rng.SpecialCells(xlCellTypeVisible).Row but that doesn't do the trick.

    I do recall there are a number of undocumented functions that I have seen here in the past but I don't remember what they are and you've got to know what you're searching for in order to do a search!

    Can someone point me in the right direction please?
    Last edited by ffffloyd; 07-17-2013 at 06:21 AM.
    _______________
    Floyd Emerson
    Business Intelligence Consultant
    Perth, Western Australia

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Keep subheaders visible at top of screen?
    By TelcoGuy in forum Excel General
    Replies: 1
    Last Post: 04-30-2013, 01:28 PM
  2. VBA macro for selecting highest visible cell
    By Jiptastic in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 03-26-2013, 06:10 PM
  3. Viewing titles of worksheets not visible on screen?
    By Snark in forum Excel General
    Replies: 1
    Last Post: 07-16-2008, 06:12 PM
  4. Problem with .Visible and Screen View
    By dvent in forum Excel General
    Replies: 0
    Last Post: 01-04-2008, 10:37 AM
  5. panes frozen, set visible part of screen
    By bodhi2.71828@gmail.com in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 02-04-2006, 11:10 PM

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