I was struggling to get SCROLLROW to work on the sheet where FREEZE PANES was active - then I read the definition of SCROLLROW which says that it scrolls within the first pane (the column titles in my case) !



How can I workaround this limitation to scroll to a chosen row in the second pane ?

I tried unfreezing the titles from VBA, which did allow SCROLLROW to work as I wemted to, but then I cannot see how to freeze the top row again whilst retaining the row I want to be visible.

Thanks

I didn't have a problem wih this:
Before:
2025-10-30_145845.jpg
After:
2025-10-30_145908.jpg
Perhaps attach a really simple workbook set up as you have it (preferably macro-less) with the row you want to scroll row to?

Thank you - you may have given me a helpful hint !

I am coming to the worksheet from another worksheet and I think that is what defaults to the upper frozen pane.

You seem to have your active cell already in the lower pane, so SCROLLROW becomes active in the lower pane.

So I am going to try first selecting a cell in the lower pane, THEN activating SCROLLROW. I will let you know how I get on . . .

Here, it worked the same way regardless of which pane the selected/active cell was in.

I will play wth it a bit more and let you know how I get on

Well I have solved this, in the most weird way !

Trying everything I could think of, I found that if I ran my procedure twice, the SCROLLROW command worked !

So, learning from the above, this is code that works . . . running fom a button on the worksheet "Tree"

1 Activate the target worksheet where I want a particular cell to be selected and visible
2 Select the particluar cell to be made visible
3 Re-activate the "Tree" worksheet
4 Activate the target woksheet again
5 Run the SCROLLROW command

Steps 3 and 4 are the surprise. I have no idea why moving away from the target worksheet and back again causes SCROLLROW to work properly.

But it does, so I'll leave it at that.

Thanks for the support