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