Solved: Scroll columns and rows

[Rejje]

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?

[frank_m]

To scroll to the upper left visible cell without selecting it:
With ActiveWindow
.ScrollRow = 1
.ScrollColumn = 1
End With

[Rejje]

Many thanks!