ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   How to display the cell it goes to at the centre of the monitor screen? (https://www.excelbanter.com/excel-discussion-misc-queries/100793-how-display-cell-goes-centre-monitor-screen.html)

cyberdude

How to display the cell it goes to at the centre of the monitor screen?
 
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


Dave Peterson

How to display the cell it goes to at the centre of the monitorscreen?
 
You have a response at your other post.

cyberdude wrote:

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


--

Dave Peterson


All times are GMT +1. The time now is 11:01 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com