PDA

View Full Version : Solved: Goto a cell and ensure that cell is in the middle of the screen



Joe Heym
02-03-2006, 08:44 AM
I know that I can use Application.Goto to move to a named cell in a worksheet, but how can I ensure that the cell I go to is always displayed roughly in the middle of the screen regardless of screen size or resolution?

Thanks

Joe

JKwan
02-03-2006, 10:44 AM
Try this:

http://www.cpearson.com/excel/zoom.htm

Joe Heym
02-03-2006, 03:13 PM
Many thanks for such a neat solution