PC Review


Reply
Thread Tools Rate Thread

Center result on screen

 
 
Mike H.
Guest
Posts: n/a
 
      12th Aug 2008
I search through data and when I find the row I am looking for, I wish to
center the data on the screen. How do I do this?
 
Reply With Quote
 
 
 
 
Gary''s Student
Guest
Posts: n/a
 
      12th Aug 2008
Hi Mike:

Sub center_it()
Application.Goto reference:=ActiveCell, scroll:=True
With ActiveWindow
i = .VisibleRange.Rows.Count / 2
j = .VisibleRange.Columns.Count / 2
..SmallScroll Up:=i, ToLeft:=j
End With
End Sub

--
Gary''s Student - gsnu200800


"Mike H." wrote:

> I search through data and when I find the row I am looking for, I wish to
> center the data on the screen. How do I do this?

 
Reply With Quote
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
Center Comments on Center of Screen Raymond W. Microsoft Excel Misc 5 15th Sep 2009 04:58 PM
Media Center blank screen & Screen Saver hangs =?Utf-8?B?UHJhdmVlbg==?= Windows Vista Hardware 4 11th Oct 2006 01:32 PM
Media Center blank screen & Screen Saver hangs =?Utf-8?B?UHJhdmVlbg==?= Windows Vista Hardware 0 4th Oct 2006 06:30 PM
Vista - screen center not in ... center =?Utf-8?B?Tmljb2xhcw==?= Windows Vista Hardware 3 27th Jun 2006 06:35 PM
center text in a formula result =?Utf-8?B?V2lsbWE=?= Microsoft Excel Worksheet Functions 2 9th Jun 2005 06:24 PM


Features
 

Advertising
 

Newsgroups
 


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