Results 1 to 3 of 3

Why Visible Range doesn't work with Freeze Pane?

Threaded View

  1. #1
    Registered User
    Join Date
    09-05-2014
    Location
    Atlanta
    MS-Off Ver
    2010
    Posts
    6

    Why Visible Range doesn't work with Freeze Pane?

    I spent hours trying to figure out and gave up and came here for some help.

    This is what I am trying to do.

    I use the following code to find out cell address of freeze pane:

    Let say Freezepane is set at cell D4

    Function Get_Curr_FreezePaneAdd_Of_ActiveSheet () as string
         Get_Curr_FreezePaneAdd_Of_ActiveSheet = Cells(ActiveWindow.SplitRow + 1, ActiveWindow.SplitColumn + 1).Address
         Get_Curr_FreezePaneAdd_Of_ActiveSheet = Replace(Get_Curr_FreezePaneAdd_Of_ActiveSheet, "$", "")
    end Function
    It perfectly gives me right cell address D4

    But let say column A is scrolled off the screen before the freeze pane was set, it gives me wrong column number. It would give me C4.
    Now to compensate for this, I figured if I can check for scrolled of column by using intersect with visible range like this:

    ColmIsVisible = Not Intersect(ActiveWindow.VisibleRange, ActiveSheet.Cells(1, 1)) Is Nothing
    OR

    ColmIsVisible = Not Intersect(ActiveWindow.VisibleRange, ActiveSheet.range("A1")) Is Nothing

    I use loop to check for first 3 (C4) columns if they are visible.
    I found out that intersect with visible range doesn't work on columns that a frozen. It considers them like they are scrolled off screen.
    It gives me false for all columns. Column A which is off screen and also false for column B and C.

    How do I find out scrolled off columns left of freeze pane cell?

    I even tried to check for column width. If they are 0 if off screen but that's only if the column is hidden.

    Who can help me?
    Last edited by Skygazer...; 10-30-2017 at 09:46 AM.

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Freeze Pane Help
    By mhitomi_7 in forum Excel General
    Replies: 1
    Last Post: 01-14-2016, 12:20 PM
  2. First Visible Row Under Freeze Pane Line
    By bdb1974 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 02-07-2012, 11:51 AM
  3. Find function doesn't work with reference and non-visible text in cell (Excel2007)
    By Wiggert in forum Excel Programming / VBA / Macros
    Replies: 11
    Last Post: 12-25-2009, 09:12 AM
  4. Freeze panes doesn't work for everyone
    By Vicki in forum Excel General
    Replies: 1
    Last Post: 05-23-2006, 08:00 AM
  5. Freeze pane
    By Marisa in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 01-11-2006, 07:55 AM
  6. Freeze pane
    By CraigMc in forum Excel General
    Replies: 2
    Last Post: 09-05-2005, 10:05 AM

Tags for this Thread

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