Wrox Programmer Forums
Go Back   Wrox Programmer Forums > Microsoft Office > Excel VBA > Excel VBA
|
Excel VBA Discuss using VBA for Excel programming.
Welcome to the p2p.wrox.com Forums.

You are currently viewing the Excel VBA section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
 
Old November 17th, 2011, 12:26 PM
Registered User
 
Join Date: Nov 2011
Posts: 4
Thanks: 1
Thanked 0 Times in 0 Posts
Default activecell in the middle of the screen

how to put the activecell in the middle of the screen with the vba in msexcel?
 
Old November 17th, 2011, 12:42 PM
Friend of Wrox
 
Join Date: Sep 2005
Posts: 812
Thanks: 1
Thanked 53 Times in 49 Posts
Default

There is a property VisibleRegion under Window. You can check if this helps you.

Dim oWin As Window
Set oWin = ActiveWindow

Cheers
Shasur
__________________
C# Code Snippets (http://www.dotnetdud.blogspot.com)

VBA Tips & Tricks (http://www.vbadud.blogspot.com)





Similar Threads
Thread Thread Starter Forum Replies Last Post
Analyze if ActiveCell is part of specified Range babers09 Excel VBA 1 June 14th, 2007 09:12 PM
Appending to the middle of a file monuindia2002 XML 4 March 8th, 2006 05:21 AM
Activecell Address vemaju Excel VBA 2 January 4th, 2006 01:36 PM
HYPERLINK in activecell icayan Excel VBA 4 May 24th, 2005 12:22 PM
changing ActiveCell sedolphi Excel VBA 1 May 17th, 2004 02:37 PM





Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright (c) 2020 John Wiley & Sons, Inc.