Why Visible Range doesn't work with Freeze Pane?

[Skygazer...]

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

Please Login or Register  to view this content.

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:

Please Login or Register  to view this content.

OR

Please Login or Register  to view this content.

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?

[alansidman]

Your post does not comply with Rule 3 of our Forum RULES. Use code tags around code.

Posting code between [CODE]Please [url=https://www.excelforum.com/login.php]Login or Register [/url] to view this content.[/CODE] tags makes your code much easier to read and copy for testing, it also maintains VBA formatting.

Click on Edit to open your thread, then highlight your code and click the # icon at the top of your post window. More information about these and other tags can be found here

(This thread should receive no further responses until this moderation request is fulfilled, as per Forum Rule 7)

[xlnitwit]

Hi,

Perhaps this

Please Login or Register  to view this content.