#1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 2
Default VBscript

Hello,
What does the top =-2 mean in this scipt. I recorded the macro and was using
it for
another sheet, and the macro stopped. When I pressed debug it pointed me to
this line. Did something change in my new sheet, how would I know. Is there a
way to fix that variable ?

Selection.Sort Key1:=Range("D2"), Order1:=xlAscending, Header:=xlGuess, _
OrderCustom:=1, MatchCase:=False, Orientation:=xlTopToBottom
With ActiveWindow
.Top = -2
.Left = 5.5
End With
Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

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


Similar Threads
Thread Thread Starter Forum Replies Last Post
Run VBScript from Excel Amy M Excel Discussion (Misc queries) 4 September 19th 08 09:07 PM
Pastespecial via vbscript not working msnews.microsoft.com[_7_] Excel Programming 2 December 20th 03 02:37 PM
How to do selection.subtotal in VBScript/ASP ? Wes[_5_] Excel Programming 3 December 9th 03 09:43 PM
Entering a formula via VBscript Jacqui Hurst Excel Programming 2 July 24th 03 04:19 PM
use shell function in vbscript Sofia Excel Programming 0 July 21st 03 06:29 PM


All times are GMT +1. The time now is 06:29 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"