+ Reply to Thread
Results 1 to 4 of 4

find first visible row in excel frozen pane

  1. 11-20-2013, 05:31 PM #1
    [email protected]
    dlebelsr@comcast.net is offline
    Registered User
    Join Date
    11-20-2013
    Location
    Nashua, NH
    MS-Off Ver
    Excel 2013
    Posts
    2

    find first visible row in excel frozen pane

    I need to set a range beginning with data in the first visible row beneath a frozen pane.
    This range would need to change as I scroll down the list.

    Is there anyway to do this?
    Thanks
    Reply With QuoteRegister To Reply
  2. 11-21-2013, 12:54 AM #2
    ryan4646
    ryan4646 is offline
    Forum Contributor ryan4646's Avatar
    Join Date
    06-10-2013
    Location
    Australia
    MS-Off Ver
    Excel 2003, 2007
    Posts
    134

    Re: find first visible row in excel frozen pane

    ur example file will help to realize and get you answered accurately and immediately.
    thanks,

    Ryan
    Reply With QuoteRegister To Reply
  3. 11-21-2013, 05:01 AM #3
    Andy Pope
    Andy Pope is offline
    Forum Guru Andy Pope's Avatar
    Join Date
    05-10-2004
    Location
    Essex, UK
    MS-Off Ver
    O365
    Posts
    20,437

    Re: find first visible row in excel frozen pane 

    Please Login or Register  to view this content.
    Will give you the cell in top left corner of movable section below frozen pane(s).
    Cheers
    Andy
    www.andypope.info
    Reply With QuoteRegister To Reply
  4. 11-21-2013, 10:47 AM #4
    [email protected]
    dlebelsr@comcast.net is offline
    Registered User
    Join Date
    11-20-2013
    Location
    Nashua, NH
    MS-Off Ver
    Excel 2013
    Posts
    2

    Re: find first visible row in excel frozen pane

    thank you, sir
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Excel 2007 : Inserting a tag within a Frozen Pane
    By novice2430 in forum Excel General
    Replies: 0
    Last Post: 12-27-2008, 05:05 PM
  2. Frozen Panes and Visible Graphs...Marti
    By Marti in forum Excel General
    Replies: 0
    Last Post: 06-25-2006, 11:20 AM
  3. [SOLVED] panes frozen, set visible part of screen
    By [email protected] in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 02-04-2006, 11:10 PM
  4. [SOLVED] Frozen Pane Lines
    By Steve in forum Excel General
    Replies: 2
    Last Post: 08-05-2005, 07:05 AM
  5. [SOLVED] How can I choose which lines are frozen using "freeze pane"?
    By emilyp in forum Excel General
    Replies: 2
    Last Post: 03-30-2005, 08:06 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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1