When Selecting a cell, also scroll the screen?

Once again while working on all my work documents I come here for help.

I am slowly learning how to do things on my own but without time to take a full course (At the moment anyways) I always come here for quick fixes..love this place.

So I have a huge document that I use for my Profit Loss for my business and it extends across 4 or 5 pages. Usually to find the page I need I have to scroll around and find what I need. Since taking over the business I have been slowly updated my dad's files to make them much easier. I added some simple buttons and macros to select certain parts of the sheet.

Please Login or Register  to view this content.

What my issue is is when selecting a cell I want that to be on the edge of the screen on the left side, and not showing the stuff to the left of the cell? Not sure this is even possible but figured I would ask. Truck out finding anything on my own.

Thanks

Try stepping through this code and see if it helps:

Please Login or Register  to view this content.

Regards, TMS

Thanks both, trying out will report back.

Worked out Now just need to modify to work on active sheet (Which I think I can manage!)

Thanks again!

You're welcome. Thanks for the rep.