freeze panes question

[braindiesel]

Hi,

Once I have panes frozen, I am using VBA to activate a specific cell.
Is there a way to ensure the selected cell becomes the top left corner of the frozen area?

 

[pboltonchina]

Try using this in your code

ActiveWindow.FreezePanes = False
'select your new cell
    ActiveWindow.FreezePanes = True