How to see a certain range of a sprdsheet at top left corner

Beastr0

New Member
Joined
Dec 28, 2004
Messages
22
I'm trying to find a way to make a certain range visible so that the top left hand corner of the range is the first cell at the top left hand corner of the visible spreadsheet.. I'm sure it's possible and probably simple.. but I can't see to find and answer...
 

Some videos you may like

Excel Facts

What do {} around a formula in the formula bar mean?
{Formula} means the formula was entered using Ctrl+Shift+Enter signifying an old-style array formula.

erik.van.geit

MrExcel MVP
Joined
Feb 1, 2003
Messages
17,832
Beastro,

You can use this
Code:
Sub selection_to_topleft()
ActiveWindow.ScrollRow = Selection(1).Row
ActiveWindow.ScrollColumn = Selection(1).Column
End Sub

kind regards,
Erik
 

Watch MrExcel Video

Forum statistics

Threads
1,123,070
Messages
5,599,611
Members
414,325
Latest member
annamsreenu

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top