View Single Post
 
Old 10-30-2025, 11:18 AM
MartinGM MartinGM is offline Windows 11 Office 2021
Competent Performer
 
Join Date: May 2023
Location: England
Posts: 115
MartinGM is on a distinguished road
Default

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
Reply With Quote