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
|