how to display the cell it goes to at the centre of the monitor screen

[cyberdude]

Hi,

After I have entered a value, I go to the cell holding the value by the
command Range.("cell_address").select to check what value I have
entered. It always goes to the cell I selected. It sometimes display
the target cell at the centre of the monitor screen but sometimes it
doesn't. How can I always make it display the target cell at the
centre of the monitor screen or somewhere as near it as possible?
Thank you.

David

 

[Cindy M -WordMVP-]

Hi Cyberdude,

After I have entered a value, I go to the cell holding the value by the
command Range.("cell_address").select to check what value I have
entered. It always goes to the cell I selected. It sometimes display
the target cell at the centre of the monitor screen but sometimes it
doesn't. How can I always make it display the target cell at the
centre of the monitor screen or somewhere as near it as possible?

Is this something you're trying to do in Word, or in Excel?

If Excel (Range.("cell-address") makes me suspect it is) then it's more
likely you'll get a quick response in the EXCEL.programming newsgroup.
This group is for WORD.VBA questions.

Cindy Meister
INTER-Solutions, Switzerland
http://homepage.swissonline.ch/cindymeister (last update Jun 17 2005)
http://www.word.mvps.org

This reply is posted in the Newsgroup; please post any follow question or
reply in the newsgroup and not by e-mail