Rejje
05-27-2011, 06:06 AM
Hi!
A worksheet's window is locked on column B. Rows in this worksheet may be hidden according to code.
Now to the poblem: Normally one could add Range("A1").Select to a macro in order to make top/left of the window to be shown. Now this doesn't work as cell A1 always can be seen.
I need a bit of code that scrolls columns to top and rows to extreme left.
Anyone able?
A worksheet's window is locked on column B. Rows in this worksheet may be hidden according to code.
Now to the poblem: Normally one could add Range("A1").Select to a macro in order to make top/left of the window to be shown. Now this doesn't work as cell A1 always can be seen.
I need a bit of code that scrolls columns to top and rows to extreme left.
Anyone able?